Home » RDBMS Server » Server Administration » Copying objects from one schema to other (UNIX Oracle 10g)
Copying objects from one schema to other [message #401605] Tue, 05 May 2009 13:39 Go to next message
dr46014
Messages: 48
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: Copying objects from one schema to other [message #401713 is a reply to message #401605] Wed, 06 May 2009 04:19 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Best way is to take export at the schema level with EXPDP/EXPORT and import it with IMPDP/IMPORT.

Thanks,
Re: Copying objects from one schema to other [message #401726 is a reply to message #401713] Wed, 06 May 2009 04:43 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, do you add anything to the previous post?
Please carefully read the question and answers before posting yourself.

Regards
Michel

[Updated on: Wed, 06 May 2009 04:43]

Report message to a moderator

Previous Topic: Disable recyclebin
Next Topic: migration methods ?
Goto Forum:
  


Current Time: Sat Dec 10 20:14:58 CST 2016

Total time taken to generate the page: 0.03747 seconds