Home » RDBMS Server » Server Utilities » DataPump errors on EXCLUDE table syntax (11.2.0.3.0 , RHL 6.2)
DataPump errors on EXCLUDE table syntax [message #668533] Wed, 28 February 2018 10:47 Go to previous message
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
Senior Member
Hi all,
I do as stated in the documentation:


https://docs.oracle.com/cloud/latest/db112/SUTIL/dp_export.htm#SUTIL884

section "Data-Only Unload of Selected Tables and Rows"

But it does not work for some reason.... does anyone know where did I go wrong with this ?

Thanks in advance...her'es my code:



SQL> create user a identified by a;

User created.

SQL> grant dba to a;

Grant succeeded.

SQL> create table a.a as select * from dba_objects;

Table created.

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@my_machine mydb]$ expdp system schemas=a directory=DATA_PUMP_DIR dumpfile=a.dmp content=DATA_ONLY EXCLUDE=TABLE:"IN ('A')"

Export: Release 11.2.0.3.0 - Production on Wed Feb 28 18:36:24 2018

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

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
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00936: missing expression

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ORA-00984: column not allowed here. date. sql loader.
Next Topic: Export/Import Unused column
Goto Forum:
  


Current Time: Tue Apr 23 19:32:40 CDT 2024