expdp遇到的问题

ORA-39002: invalid operation

ORA-39070: Unable to open thelog file.

ORA-29283: invalid fileoperation

ORA-06512: at"SYS.UTL_FILE", line 536

ORA-29283: invalid fileoperation

这是因为DBA定义了directory变量，但是server上没有physical的folder

解决方案，找DBA建这个folder

ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00920: invalid relational operator

IN和后面的括号不能有空格

LRM-00116

需要对双引号转义，在windows用\转。

最后成功的语句

expdp testowner/testowner@IR4ST SCHEMAS=TESTOWNER DIRECTORY=backup_dmp LOGFILE=expdp_1.log DUMPFILE=expdp_1.dmp EXCLUDE=TABLE:\"IN('test_table')\"

参考的blog

http://blog.csdn.net/liqfyiyi/article/details/7248911