OraFAQ Forum: Server Administration » Copying objects from one schema to other

Home » RDBMS Server » Server Administration » Copying objects from one schema to other (UNIX Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

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

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,

Report message to a moderator

Re: Copying objects from one schema to other [message #401726 is a reply to message #401713]

Wed, 06 May 2009 04:43

Michel Cadot
Messages: 68665
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 02:43:25 CDT 2024