Home » RDBMS Server » Server Utilities » import dump (oracle 10g)
icon5.gif  import dump [message #636156] Sat, 18 April 2015 06:17 Go to next message
asifkhan1990.cse
Messages: 11
Registered: February 2015
Location: INDIA
Junior Member

Dear all,

by mistake some tables are trucated from db.i have to import a dmp file.how can i import file to over write the exsiting data.

Thanks.

Re: import dump [message #636157 is a reply to message #636156] Sat, 18 April 2015 06:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Is this a real problem, or some sort of learning exercise or perhaps an interview question?

Re: import dump [message #636160 is a reply to message #636157] Sat, 18 April 2015 08:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how can i import file to over write the exsiting data.
What existing data? Tables were truncated.

BTW Oracle 10g is obsoleted & unsupported.
Re: import dump [message #636167 is a reply to message #636156] Sat, 18 April 2015 11:09 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
You could use the following parameter:

CONTENT=DATA_ONLY


From documentation,

Quote:
DATA_ONLY loads only table row data into existing tables; no database objects are created.



Regards,
Lalit
Previous Topic: How to Import Data
Next Topic: Exclude Table in Schema Level
Goto Forum:
  


Current Time: Thu Mar 28 20:07:46 CDT 2024