Home » RDBMS Server » Server Utilities » User Schema Migration
User Schema Migration [message #304356] Wed, 05 March 2008 00:15 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Hi

I want to migrate a user’s complete schema with data from one database instance of Oracle 10g to another database instance to Oracle10g on a different machine in same network.
Data is not huge so performance is not an issue.
Please advise the best way.

Wishes

Report message to a moderator

Re: User Schema Migration [message #304367 is a reply to message #304356] Wed, 05 March 2008 00:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
exp/imp
fromuser
touser

Report message to a moderator

Re: User Schema Migration [message #304369 is a reply to message #304356] Wed, 05 March 2008 00:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DataPump

Regards
Michel

Report message to a moderator

Re: User Schema Migration [message #304373 is a reply to message #304369] Wed, 05 March 2008 00:32 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
is there any option other then imp exp???

wishes

Report message to a moderator

Re: User Schema Migration [message #304375 is a reply to message #304373] Wed, 05 March 2008 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DataPump.

Regards
Michel

Report message to a moderator

Re: User Schema Migration [message #304408 is a reply to message #304375] Wed, 05 March 2008 01:31 Go to previous message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Of course, if you are a little bit masochistic, and regarding the fact that data volume isn't that high, you might even manually create all tables and insert data into them. A little bit faster way would be CTAS (Create Table As Select). You'd still have to create all indexes, triggers, procedures, etc. So ... why wouldn't you rather use Export/Import or Datapump utilities?

Report message to a moderator

Previous Topic: sqlldr -direct path loading
Next Topic: Bad files when using multiple input files with sqlldr
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 04:15:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.