linux expdp&expdp

expdp 用法﹕

創建directory :     

conn sys/oracle as sysdba

create directory dump_file as '/home/oracle';

grant read,write on directory dump_file to system;

1﹑在parfile 參數文件中寫入﹕文件名為par.file

     SCHEMAS=win                                                  ----導出schemas=win的object
     DIRECTORY=dump_file                                  ----導出的文件所放在的位置/home/oracle目錄下
     dumpfile=dp.dmp                                              ----導出的文件的名字為dp.dmp
     LOGFILE=exp.log                                              
     INCLUDE=TABLE:"IN (SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE WNER='WIN'   AND  OBJECT_TYPE='TABLE')"                                ----導出win用戶下所有table.

然后執行 expdp system/manager  parfile=par.file 即可以導出win用戶下所有的table.

2﹑導出win用戶下所有的object

     expdp system/password DIRECTORY=dump_file dumpfile=dp.dmp SCHEMAS=win

3﹑導出全庫

 expdp system/password DIRECTORY=dump_file dumpfile=dp.dmp full=y

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14876437/viewspace-555221/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14876437/viewspace-555221/