星期三, 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預設帳號,可以參考這篇...

Oracle 各帳號用途清查 for 9i/10g/11g


沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...