Home » Other » General » copying all of the objects in one schema over to another schema
copying all of the objects in one schema over to another schema [message #217234] Thu, 01 February 2007 04:47 Go to next message
sureshcharan
Messages: 2
Registered: May 2006
Junior Member
Hi,

Can we copy all of the objects in one schema over to another schema name in oracle?what i mean is duplicating all of the objects (tables, indexes, views, MQTs, functions, etc) from one schema to another (in the same or different tablespace) with or without the data.

Is there any other way or workaround to do this,without using import and export utilities provided by oracle?


Re: copying all of the objects in one schema over to another schema [message #217247 is a reply to message #217234] Thu, 01 February 2007 05:35 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export and import utilities have been designed for such a purpose. Why wouldn't you use them?

Of cours, you might try to move all objects to another schema one by one or even develop your own "migration" tool, but - is it worth the pain when Oracle has already provided those utilities?
Previous Topic: postponed commits possible?
Next Topic: multiple oracle sessions
Goto Forum:
  


Current Time: Sat Dec 03 00:52:41 CST 2016

Total time taken to generate the page: 0.09802 seconds