Home » RDBMS Server » Server Utilities » Import only tables of a schema (oracle 11.2.0.3.0 - Windows server 2007 R2)
Import only tables of a schema [message #591326] Fri, 26 July 2013 06:43 Go to next message
muktha_22
Messages: 397
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
Re: Import only tables of a schema [message #591330 is a reply to message #591326] Fri, 26 July 2013 07:19 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Research IMPDP's INCLUDE parameter.
Re: Import only tables of a schema [message #592371 is a reply to message #591330] Wed, 07 August 2013 04:39 Go to previous messageGo to next message
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.
Re: Import only tables of a schema [message #592377 is a reply to message #592371] Wed, 07 August 2013 05:40 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: exp/imp failed on nasted table.
Next Topic: User creation while impdp
Goto Forum:
  


Current Time: Sat Oct 25 01:16:53 CDT 2014

Total time taken to generate the page: 0.09766 seconds