Home » RDBMS Server » Server Utilities » Import dump (Oracle 10g, 10.2.0.2.0 , Unix)
Import dump [message #493249] Mon, 07 February 2011 01:43 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


Hi,

I have exported a schema dump with schema name as 'A'.I want to import that dump in to schema 'B'.

how ?


Thanks

Re: Import dump [message #493255 is a reply to message #493249] Mon, 07 February 2011 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How did you dump?

Regards
Michel
Re: Import dump [message #493266 is a reply to message #493255] Mon, 07 February 2011 03:25 Go to previous messageGo to next message
Littlefoot
Messages: 21624
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I understood: schema "B" is owned by user "B", so you need to use user B's credentials.

For example: this is how you performed export:
exp a/apw file=a_export.dmp

Now you'll import it into B's schema using
imp b/bpw file=a_export.dmp

Import utility will notify you that export was done by user "A", not you (user "B"), but that's OK.

If that's not how you did it, well, I guess you'll need to describe steps you made.
Re: Import dump [message #493754 is a reply to message #493266] Wed, 09 February 2011 12:27 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
Littlefoot wrote on Mon, 07 February 2011 04:25

Import utility will notify you that export was done by user "A", not you (user "B"), but that's OK.


Unless A had dba rights and B does not in which case the import will fail entirely.
Re: Import dump [message #494123 is a reply to message #493754] Fri, 11 February 2011 07:42 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
imp / file=a_export.dmp fromuser=A touser=B

[Updated on: Fri, 11 February 2011 07:50] by Moderator

Report message to a moderator

Re: Import dump [message #494129 is a reply to message #494123] Fri, 11 February 2011 07:51 Go to previous message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Valid ONLY if OP used exp to "export".

Regards
Michel
Previous Topic: Job Scheduler
Next Topic: sqlloader vs external tables
Goto Forum:
  


Current Time: Thu Dec 03 23:14:00 CST 2020