OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import dump (oracle 10g)

Sat, 18 April 2015 06:17

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.

Sat, 18 April 2015 06:23

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

Is this a real problem, or some sort of learning exercise or perhaps an interview question?

Sat, 18 April 2015 08:29

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.

Sat, 18 April 2015 11:09

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: Sat Mar 25 05:20:35 CDT 2023