OraFAQ Forum: Server Utilities » Importing a schema

Home » RDBMS Server » Server Utilities » Importing a schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing a schema [message #266861]

Tue, 11 September 2007 17:59

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.

Report message to a moderator

Re: Importing a schema [message #266862 is a reply to message #266861]

Tue, 11 September 2007 18:19

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

Re: Importing a schema [message #266905 is a reply to message #266861]

Tue, 11 September 2007 23:59

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

Report message to a moderator

Re: Importing a schema [message #267140 is a reply to message #266905]

Wed, 12 September 2007 10:13

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 09:44:09 CST 2024