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