Home » RDBMS Server » Server Utilities » Importing a schema
Importing a schema [message #266861] Tue, 11 September 2007 17:59 Go to next message
srp_appsdba
Messages: 3
Registered: September 2007
Junior Member
I have a schema dump available.
I need to import it to another database.

Do I need to create a user with same schema name and import it.

Pls guide me.
Re: Importing a schema [message #266862 is a reply to message #266861] Tue, 11 September 2007 18:19 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Do I need to create a user with same schema name and import it.
You'll need to create "a" schema, but it does not have to be the same name as the originating schema.

Below shows all the command line options available for the import utility.

imp help=yes

Complete documentation can be found at http://tahiti.oracle.com in the Utilities Manual.

[Updated on: Tue, 11 September 2007 18:20] by Moderator

Report message to a moderator

Re: Importing a schema [message #266869 is a reply to message #266861] Tue, 11 September 2007 21:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is totally based your requirement whether you need or not. No one else can tell you.
Re: Importing a schema [message #266905 is a reply to message #266861] Tue, 11 September 2007 23:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
If you have schema/user level exported dump file then you have to use below parameters with import scripts.

IMP userid/pwd FILE=OS_PATH LOG=OS_PATH FROMUSER=username TOUSER=username

FROMUSER list of owner usernames(target exported dump file user)
TOUSER list of usernames (user where you want to import this dump file)



Regards
Mohammed Taj
Re: Importing a schema [message #267140 is a reply to message #266905] Wed, 12 September 2007 10:13 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
and if on 10g (datapump) then use

REMAP_SCHEMA=olduser:newuser

[Updated on: Wed, 12 September 2007 10:13]

Report message to a moderator

Previous Topic: sqlldr when
Next Topic: Data pump to transfer file from previous version of Oracle
Goto Forum:
  


Current Time: Thu Dec 08 21:56:36 CST 2016

Total time taken to generate the page: 0.06245 seconds