Data pump export
Trying to export
I need all of this data from production:
select * from custom_list_value where custom_field_id in (271720,261773);
myparfile
directory=BOA_DATA_PUMP
dumpfile=custom_list_value.dmp
logfile=custom_list_value.log
buffer=6553600
schemas=cgadmin
INCLUDE=TABLE:"IN (select * from cgadmin.custom_list_value where custom_field_id in (271720,261773))"
getting this error
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 INCLUDE is badly formed.
ORA-00913: too many values
what's the correct syntax??
thank you.