Home » RDBMS Server » Server Utilities » Merge two distinct schema ( Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi, Sun Solaris 10)
Merge two distinct schema [message #453551] Thu, 29 April 2010 10:36 Go to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
I have a requirement to add all the objects of schema A of database X to schema B of database Y. Schema A and B does not have any common objects.

Apart from tables,indexes schema A also have BLob object, materialize views, type. The size of database X is 50 GB.

Through initial reseach I found data pump , traspoting tablespaces , and RMAN duplication .

Is the any other method I should be looking at?

Is RMAN duplication even a option because I just want to copy a schema not the whole database? The data base has other schemas too.

What would be the recommended way to do it?

I will highly appreciate any suggestion and opinion.
Re: Merge two distinct schema [message #453554 is a reply to message #453551] Thu, 29 April 2010 10:44 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Just to clarify, does schema B already have objects that you want to leave alone?
Re: Merge two distinct schema [message #453555 is a reply to message #453554] Thu, 29 April 2010 10:47 Go to previous messageGo to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
cookiemonster wrote on Thu, 29 April 2010 10:44
Just to clarify, does schema B already have objects that you want to leave alone?


Yes, Schema B has it own object which shoud be left alone.
Re: Merge two distinct schema [message #453567 is a reply to message #453551] Thu, 29 April 2010 12:25 Go to previous messageGo to next message
joy_division
Messages: 4951
Registered: February 2005
Location: East Coast USA
Senior Member
spur230 wrote on Thu, 29 April 2010 11:36

Apart from tables,indexes schema A also have BLob object, materialize views, type. The size of database X is 50 GB.
.


What about the size of schema A?
Re: Merge two distinct schema [message #453572 is a reply to message #453567] Thu, 29 April 2010 13:07 Go to previous messageGo to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
Schema A is 30 GB

[Updated on: Thu, 29 April 2010 13:08]

Report message to a moderator

Re: Merge two distinct schema [message #453737 is a reply to message #453572] Fri, 30 April 2010 08:23 Go to previous messageGo to next message
spur230
Messages: 25
Registered: April 2009
Location: US
Junior Member
Any suggestion / recommendation please?
Re: Merge two distinct schema [message #453773 is a reply to message #453737] Fri, 30 April 2010 15:25 Go to previous message
Littlefoot
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd use export/import /forum/fa/3314/0/ If you started it yesterday, it would already be over by now.
Previous Topic: Imp db oracle
Next Topic: expdb remap_schema
Goto Forum:
  


Current Time: Sun Sep 19 21:42:43 CDT 2021