Wednesday, May 2, 2012

ORA-39071: Value for TABLES is badly formed

A colleague of mine was trying to export tables with expdp when he got the error
ORA-39071: Value for TABLES is badly formed

He( His name is Patrick Kamper) also foud the solution:
put the list of tables to export into a table

SQL> insert into pka003.export_tables values ('T_AGT_BUSI_PDT');
SQL>  insert into pka003.export_tables values ('T_AGT_PRDT_RATE');
SQL> commit;

expdp \'/ as sysdba\' dumpfile=BAO401T1.expdp logfile=BAO401T1 \
schemas=BAO4_OWN include=table:\"in \(select table_name from pka003.export_tables\)\"

Now a quote from patrick

Oracle Rules.

No comments:

Post a Comment