第一步:sqlplus system/egis@orcl as sysdba; 进入sqlplus (输入管理员用户名/密码@数据库密码)
第二步: create directory dumpdir as 'd:\'; 创建数据库泵目录(指定泵目录的地址)
第三步: exit 退出sqlplus
第四步:expdp portal_gdms/portal_gdms@orcl dumpfile=filenmame.dmp directory=dumpdir version=10.0.2
(
Microsoft Windows [版本 6.1.7600]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\thinkpad>sqlplus system/egis@orcl as sysdba;
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 3月 15 21:21:06 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create directory dumpdir as 'd:\';
目录已创建。
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Rea