1. 导出密码包含特殊字符@等。
expdp 'system/"@3423423"'@127.0.0.1/orcl directory=$directory dumpfile=$bakdata logfile=$baklog schemas=$orowner
2.导出时如何排除某些表
导出时总会出现一个问题,
出现该问题时需要转义
1) 只排除某个表
expdp 'system/"@3423423"'@127.0.0.1/orcl directory=$directory dumpfile=$bakdata logfile=$baklog schemas=$orowner EXCLUDE=TABLE:"\=\'CT_BD_ADAPTERINTERFACELOG'"
2)排除多个表
expdp 'system/"@3423423"'@127.0.0.1/orcl directory=$directory dumpfile=$bakdata logfile=$baklog schemas=$orowner EXCLUDE=TABLE:\"in\(\'CT_BD_ADAPTERINTERFACELOG\',\'T_LOG_APP\',\'SYS_IMPORT_SCHEMA_01\'\)\"