| copying all of the objects in one schema over to another schema [message #217234] |
Thu, 01 February 2007 04:47  |
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  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
