Hi Gurus,
Tired of trying different things, finally coming to you folks to help me out. I am trying to export a table with a query option. I tried all the options but its not working and give me again n again the same error.
My Environment -
DB - 11gr2 (11.2.0.4)
Host - Red Hat Enterprise Linux Server release 5.9 (Tikanga)
RAC - Yes with ASM (3 nodes) with physical standby.
ORA-39001: invalid argument value
ORA-39035: Data filter SUBQUERY has already been specified
PAR file -
USERID=deadm/xxxxxxx
directory=DATA_EXP
dumpfile=expdp_tables.dmp
logfile=expdp_tables.log
CONTENT=DATA_ONLY
tables=NODE,NODE_ROLE,RIGHTS_BILLING_TRANSACTION
QUERY=RIGHTS_BILLING_TRANSACTION:\"WHERE CONTENT_ID IN \('urn:dece:cid:eidr-s:773C-F85A-E354-5C02-B1F5-L','urn:dece:cid:eidr-s:707F-60A0-3411-0DC3-2498-4'
Note - In query part I have just put a part of query. There are many such fields. Overall query is about 39 lines.
Thing i have tried.
1) I tried with system user but it again gives the same error.
2) I tried to escaped all special characters but it fails with same error. eg QUERY=RIGHTS_BILLING_TRANSACTION:\"WHERE CONTENT_ID IN \(\'urn\:dece\:cid\:eidr\-s\:773C\-F85A\-E354\-5C02\-B1F5\-L\',\'urn\:dece\:cid\:eidr\-s\:707F\-60A0\-3411\-0DC3
3) I tried to break the query so that it wont give SP2-0027: Input is too long (> 2499 characters) - line ignored error and used it in query part... but it wont help.
Gurus, please help me with your experience.
Regards,
Lancerique.