Home » RDBMS Server » Server Utilities » How to import just the data using data pump
How to import just the data using data pump [message #206109] Tue, 28 November 2006 16:33 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Using Data Pump utility, how do I just import just the data only. I do not want any table structure (metadata of the table)to be imported.
What parameter/syntax need to be used in impdp.
Can someone help me.
Thanks
Re: How to import just the data using data pump [message #206115 is a reply to message #206109] Tue, 28 November 2006 17:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look into TABLE_EXISTS_ACTION
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#sthref364

It is just an excellent enhancement for the IGNORE=Y option with imp.
With impdp you can skip/append/truncate or replace
Re: How to import just the data using data pump [message #206367 is a reply to message #206109] Wed, 29 November 2006 14:31 Go to previous message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Thanks Mahesh.
That is an excellent feature on impdp.
Previous Topic: broadcasting mesage to all users as DBA
Next Topic: Load data from URL
Goto Forum:
  


Current Time: Thu Dec 08 10:07:44 CST 2016

Total time taken to generate the page: 0.22264 seconds