OraFAQ Forum: Server Utilities » how to create target database while importing full database

Home » RDBMS Server » Server Utilities » how to create target database while importing full database

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

how to create target database while importing full database [message #234425]

Tue, 01 May 2007 09:49

bluepower
Messages: 10
Registered: April 2007
Location: new delhi

Junior Member

hello,

I want to export full database of same version(9i) and on same platform(linux)....for dis i don't know how mah target database structure should be... is it mandatory dt target databases hould be same as the source one or can it be different..... do i need to precreate all the tablespaces or will they get created automatically...
I want to have a different target database structure....
what steps i have to do for successful import?

reply will be appreciated....

bhumika

[Updated on: Tue, 01 May 2007 09:50]

Report message to a moderator

Re: how to create target database while importing full database [message #234426 is a reply to message #234425]

Tue, 01 May 2007 09:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>do i need to precreate all the tablespaces or will they get created automatically
A full import will try to create the same tablespaces and will succeed if the disk layout/File paths are available as in source.
It is better to precreate the tablespaces and do import.
>>what steps i have to do for successful import?
Too many variants to list them all Smile

Report message to a moderator

Re: how to create target database while importing full database [message #234428 is a reply to message #234426]

Tue, 01 May 2007 09:58

bluepower
Messages: 10
Registered: April 2007
Location: new delhi

Junior Member

thanks fr u reply sir

can I precreate all the tablespaces having different names and paths on the target database

hope will get reply soon

Report message to a moderator

Re: how to create target database while importing full database [message #234430 is a reply to message #234428]

Tue, 01 May 2007 10:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Different paths OK.
Different names could be a problem (for a FUll database import. Becuase Imp will try to assign those same tablepsaces to users).
If you can afford to use fromuser/touser option(user by user) you can have any tablespace name too.

Report message to a moderator

Re: how to create target database while importing full database [message #234433 is a reply to message #234430]

Tue, 01 May 2007 10:11

bluepower
Messages: 10
Registered: April 2007
Location: new delhi

Junior Member

sir u mean u to say while exporting full database I've to create the tablespaces with the same name as in source database....and if i want to have different name then have to import schemas individually........
thanks fr ur replies sir
really i m new to this orafaq nd now i m feeling gud to be a part of it

Report message to a moderator

Previous Topic:	SQL * Loader problem
Next Topic:	Sql*Loader conventional path - lock table ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 11:46:03 CST 2024