Database Utilities (MOSC)

MOSC Banner

expdp include query ORA-39071: Value for INCLUDE is badly formed.

edited Jul 30, 2012 1:03AM in Database Utilities (MOSC) 5 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center