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

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.

Bye
Ashutosh Trivedi

Report message to a moderator

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: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export just the concerned table.
Import with ignore=y

Report message to a moderator

Re: Import related query [message #191673 is a reply to message #191116] Thu, 07 September 2006 12:55 Go to previous message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member
Hi

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.


Thanks,

Mohan Reddy G

Report message to a moderator

Previous Topic: Protecting Unrecoverable Changes
Next Topic: how can asm datafile is deleted
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 30 19:15:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.