OraFAQ Forum: Server Utilities » Import only tables of a schema

Home » RDBMS Server » Server Utilities » Import only tables of a schema (oracle 11.2.0.3.0 - Windows server 2007 R2)

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

Import only tables of a schema [message #591326]

Fri, 26 July 2013 06:43

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Kindly any one tell me the way to do IMPORT of a schema's ALL the TABLES only. Through Data Pump.
I dont want to import any other objects like 'package',procedure etc...

Is it the only way is specifying them within EXCLUDE parameter?

Regards
Muktha

Report message to a moderator

Re: Import only tables of a schema [message #591330 is a reply to message #591326]

Fri, 26 July 2013 07:19

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Research IMPDP's INCLUDE parameter.

Report message to a moderator

Re: Import only tables of a schema [message #592371 is a reply to message #591330]

Wed, 07 August 2013 04:39

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

i think u'll have to use for example INCLUDE=TABLE:"LIKE 'DR$%'" along with impdp.

Report message to a moderator

Re: Import only tables of a schema [message #592377 is a reply to message #592371]

Wed, 07 August 2013 05:40

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why do you answer to quite old topics that are obviously ended to repeat about the same things that have been posted?

Regards
Michel

Report message to a moderator

Previous Topic:	exp/imp failed on nasted table.
Next Topic:	User creation while impdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 12 10:36:35 CDT 2026