expdp exclude/include 命令出錯

expdp rtms/rtms directory=dump_dir dumpfile=XXX exclude=TABLE:"IN ('AA','BB','CC','EE','EE')"


Export: Release 11.2.0.1.0 - Production on Mon Feb 9 11:38:24 2015


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00936: missing expression

經查，為在Linux系統中跳脫字元的問題，在win下應該正常

>寫上了 table:in('XXX')，table:in('ZZZ') 發現還必須大寫
因為使用了單引號，類似於SQL語句中的IN寫法。

>還不能連著寫？？TABLE:IN('XXX','ZZZ')??
可以連著寫。如果在命令列中使用，而不使用PARFILE選項將條件寫在引數檔案中，一定要注意特殊字元的轉義。
EXCLUDE=TABLE:\"IN\(\'T\',\'T_TEST\'\)\"