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: 188
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


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: 25033
Registered: January 2009
Location: SoCal
Senior Member
exp/imp
fromuser
touser
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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DataPump

Regards
Michel
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: 188
Registered: April 2005
Location: Islamabad
Senior Member

is there any option other then imp exp???

wishes
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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DataPump.

Regards
Michel
Re: User Schema Migration [message #304408 is a reply to message #304375] Wed, 05 March 2008 01:31 Go to previous message
Littlefoot
Messages: 20888
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?
Previous Topic: sqlldr -direct path loading
Next Topic: Bad files when using multiple input files with sqlldr
Goto Forum:
  


Current Time: Fri Dec 02 16:58:21 CST 2016

Total time taken to generate the page: 0.39900 seconds