expdp include query ORA-39071: Value for INCLUDE is badly formed.
Hi all,
I don't know where I'm missing here but I'm getting this erros when trying to do a expdp with INCLUDE clause:
#########################################################################################################
[oracle@g2 ~]$ expdp system/manager DIRECTORY=dirteste DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log SCHEMAS=ggadm INCLUDE=TABLE:\"IN \(SELECT object_name FROM scott.expdp_tab WHERE owner=\'SCOTT\' AND object_type=\'TABLE\'\)\"
Export: Release 11.2.0.3.0 - Production on Mon Jul 9 12:32:09 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
0