OraFAQ Forum: Server Utilities » Multiple "Include" in impdp

Home » RDBMS Server » Server Utilities » Multiple "Include" in impdp (Oracle Db 11gR2V3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multiple "Include" in impdp [message #628112]

Thu, 20 November 2014 04:02

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

Report message to a moderator

Re: Multiple "Include" in impdp [message #628132 is a reply to message #628112]

Thu, 20 November 2014 05:13

Michel Cadot
Messages: 67650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can use multiple INCLUDE.

Report message to a moderator

Re: Multiple "Include" in impdp [message #628158 is a reply to message #628132]

Thu, 20 November 2014 10:39

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

Report message to a moderator

Re: Multiple "Include" in impdp [message #628161 is a reply to message #628158]

Thu, 20 November 2014 11:20

Michel Cadot
Messages: 67650
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.

Report message to a moderator

Re: Multiple "Include" in impdp [message #628341 is a reply to message #628161]

Mon, 24 November 2014 06:12

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_%".

Report message to a moderator

Re: Multiple "Include" in impdp [message #628346 is a reply to message #628341]

Mon, 24 November 2014 06:32

Michel Cadot
Messages: 67650
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 24 01:34:46 CST 2021