| Merge two distinct schema [message #453551] |
Thu, 29 April 2010 10:36  |
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 #453555 is a reply to message #453554] |
Thu, 29 April 2010 10:47  |
spur230
Messages: 25
Registered: April 2009
Location: US
|
Junior Member |
|
|
cookiemonster wrote on Thu, 29 April 2010 10:44Just 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 |
joy_division
Messages: 4963
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?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
