Home » RDBMS Server » Backup & Recovery » Import related query
Import related query [message #191116] Mon, 04 September 2006 13:20 Go to next message
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member

I want to import the data of the costxx_cost_master data only by using the imp command . because I have the table strucrure already there .

Can anybody help me in this regards. Please send me steps.

Ashutosh Trivedi
Re: Import related query [message #191117 is a reply to message #191116] Mon, 04 September 2006 13:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export just the concerned table.
Import with ignore=y
Re: Import related query [message #191673 is a reply to message #191116] Thu, 07 September 2006 12:55 Go to previous message
Messages: 52
Registered: August 2006
Location: India


You have dmp file you can directly import the particular table or some table only.

imp userid=system/manager@foo file=c:\foo.dmp log=c:\foo.log fromuser=foo touser=foo rows=y ignore=y table=(foo)

it will import the rows of foo table.


Mohan Reddy G
Previous Topic: RMAN backup&dbms_scheduler
Next Topic: Backup database using RMAN Error
Goto Forum:

Current Time: Sun Aug 20 20:01:51 CDT 2017

Total time taken to generate the page: 0.06269 seconds