ORA-39071: Value for EXCLUDE is badly formed.

在用expdp/impdp 导出导入数据的时候,有时候我们会用 exclude排除某些表的时候会报如下的错误:
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00933: SQL command not properly ended

 

ORA-39071: Value for EXCLUDE is badly formed.

 那么在linux系统下正确的写法应该如下所示:

[[email protected] ~]$ impdp dairy/[email protected] schemas=dairy directory=DUMP_DIR table_exists_action=append  content=data_only dumpfile=dump20180911.dmp logfile=dump20180911.log  exclude=TABLE:\"IN \'T_COMP_MSG\'\'LOG_COMMSG\'\"

ORA-39071: Value for EXCLUDE is badly formed.