IT 研究室 ( 前IT DBA's 資訊站): [Example] Oracle data pump full import exclude system internal users

星期三, 2月 06, 2013

[Example] Oracle data pump full import exclude system internal users

匯出時用full mode即可
#export

create directory expdp_dir as '/oracle/backup/expdp';

expdp \'/ as sysdba\' full=y directory=expdp_dir dumpfile=full.dmp logfile=full_expdp.log

#匯入時，把default account都排除掉

impdp \'/ as sysdba\' full=y EXCLUDE=SCHEMA:\"in \(\'SYS\',\'SYSTEM\',\'WKSYS\',\'OLAPSYS\',\'TSMSYS\',\'SYSMAN\',\'OUTLN\',\'WK_TEST\',\'MGMT_VIEW\',\'APPQOSSYS\',\'DBSNMP\',\'DIP\',\'ORACLE_OCM\'\)\" directory=expdp_dir dumpfile=full.dmp logfile=full_impdp.log

想排除更多Oracle預設帳號，可以參考這篇...