C:\Documents and Settings\Administrator> sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 9月 29 17:15:24 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn system/system as sysdba;
已连接。
SQL> create directory mypump as 'd:\ExistsDir';---将目录指定到已经存在数据文件(*.dmp)的文件夹上
目录已创建。
SQL> grant read,write on directory mypump to system;---->给当前目录授权
授权成功。
SQL> select * from dba_directories;---->查询当前数据库存在的所有directory
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS MEDIA_DIR
e:\oracle\ora92\demo\schema\product_media\
SYS LOG_FILE_DIR
e:\oracle\ora92\demo\schema\log\
SYS DATA_FILE_DIR
e:\oracle\ora92\demo\schema\sales_history\
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS MYPUMP
d:\ExistsDir ------------->该目录为我刚刚建立的数据目录
<导出数据>
SQL> expdp system/oracle directory =mypump
dumpfile=expdpbak.dmp logfile=exp.log
schemas=orcl
SQL> impdp username/userpwd directory =mypump
dumpfile=day1.dmp logfile=day0.log
schemas=orcl