| Copying objects from one schema to other [message #401605] |
Tue, 05 May 2009 13:39  |
dr46014
Messages: 49
Registered: February 2007
|
Member |
|
|
Hi All
I am a part of development project where we have to create separate schema for different projects.The problem we are facing is that for each schema we have to create the same set of objects(tables/views/indexes) with latest partitions in the table each time.
Is there any simplified way to copy the objects from one schema to other directly.Lets say one of the DB X has a schema X_owner which is having the latest objects with recent month partiions.Can i copy all the objects from schema X_owner to another schema Y_owner in a DB Y.
The DB may be in the same or different server.
Please suggest any simplified method where we can do this redundant activity with ease.
|
|
|
|
| Re: Copying objects from one schema to other [message #401606 is a reply to message #401605] |
Tue, 05 May 2009 13:48  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
If the volume of data is less,
Export / Import Or Expdp / Impdp is one way.
Edit:
Since this is a Dev environment,
I suppose volume of data should be very less.
Above said tools are meant for this purpose.
You can copy everything (tables and data) or just objects (no data) or even selectively (list the tables you want to copy).
[Updated on: Tue, 05 May 2009 13:52] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
