Database Utilities (MOSC)

MOSC Banner

Data pump export

edited Jul 4, 2014 5:00AM in Database Utilities (MOSC) 8 commentsAnswered

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.

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