Home » RDBMS Server » Server Utilities » Multiple "Include" in impdp (Oracle Db 11gR2V3)
icon4.gif  Multiple "Include" in impdp [message #628112] Thu, 20 November 2014 04:02 Go to next message
er.mohitag
Messages: 3
Registered: November 2014
Location: Hyderabad
Junior Member
I am trying to add multiple like conditions as want to import table staring with multiple texts But not able to do that.
Can anyone help me.

IMPDP ..... include=TABLE:\"LIKE 'UNIFIER_%'\" OR \"LIKE 'SYS_%'\"

Error - ORA-39001: invalid argument value
ORA-39071: Value for INCLUDE is badly formed.
ORA-00907: missing right parenthesis
Re: Multiple "Include" in impdp [message #628132 is a reply to message #628112] Thu, 20 November 2014 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can use multiple INCLUDE.

Re: Multiple "Include" in impdp [message #628158 is a reply to message #628132] Thu, 20 November 2014 10:39 Go to previous messageGo to next message
er.mohitag
Messages: 3
Registered: November 2014
Location: Hyderabad
Junior Member
Multiple include by default has and constraint
How can we make that OR constraint
Re: Multiple "Include" in impdp [message #628161 is a reply to message #628158] Thu, 20 November 2014 11:20 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Multiple include by default has and constraint


I have no idea of what this means.

Re: Multiple "Include" in impdp [message #628341 is a reply to message #628161] Mon, 24 November 2014 06:12 Go to previous messageGo to next message
er.mohitag
Messages: 3
Registered: November 2014
Location: Hyderabad
Junior Member
Hi Michel,

Sorry for coming back late on this.

I have tried with multiple INCLUDE statements, and found that internally Oracle implements "AND" condition to them. Thus, if the "AND" condition fails, the IMPDP has no tables imported.

What have I tried so far is :

IMPDP ..... include=TABLE:\"LIKE 'UNIFIER_%'\" OR \"LIKE 'SYS_%'\"

Error - ORA-39001: invalid argument value
ORA-39071: Value for INCLUDE is badly formed.
ORA-00907: missing right parenthesis


When tried with multiple INCLUDE in a param file:

include=TABLE:"LIKE 'UNIFIER_%'" 
include=TABLE:"LIKE 'SYS_%'"


I don't see these tables imported at all. As I think Oracle internally applies "AND" condition for the multiple INCLUDE commands.

Please let me know if you need to see the log file and a test case.

At high level, my requirement is, to import only the required tables and that I just know that each category of tables have particular PREFIX. So, I want to import all the TABLES having PREFIX as "UNIFIER_%" OR "SYS_%".


Re: Multiple "Include" in impdp [message #628346 is a reply to message #628341] Mon, 24 November 2014 06:32 Go to previous message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ah yes, understood, it seems that impdp does an OR when object types are different and an AND when there are same ones.
I don't see other solution than to import twice, one per each expression.

Previous Topic: Dump size is more that size available in dba_data_files
Next Topic: Is Datapump Export is Possible in Oracle Client
Goto Forum:
  


Current Time: Mon Jun 17 17:41:38 CDT 2019