OraFAQ Forum: Server Utilities » How to import just the data using data pump

Home » RDBMS Server » Server Utilities » How to import just the data using data pump

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

How to import just the data using data pump [message #206109]

Tue, 28 November 2006 16:33

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

Report message to a moderator

Re: How to import just the data using data pump [message #206115 is a reply to message #206109]

Tue, 28 November 2006 17:49

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: How to import just the data using data pump [message #206367 is a reply to message #206109]

Wed, 29 November 2006 14:31

pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville

Senior Member

Thanks Mahesh.
That is an excellent feature on impdp.

Report message to a moderator

Previous Topic:	broadcasting mesage to all users as DBA
Next Topic:	Load data from URL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:54:43 CDT 2024