Database Administration (MOSC)

MOSC Banner

move some schema to new database

I have Oracle RAC 19.3 2 nodes on linux 7 with Standby database single node.

the database consisits of multiple schema suming up to size 3 TB . we decided to move some schema to a new a database these schema are of 1TB size.

for this purpose i considered the 2 options below:

1- create a new standby database for the existing one and the open it as new PROD 2 and drop unwanted schema from it. this will have no downtime on the current prod

2- export required schema and import them on the new DB . this will require downtime to take the export of the schema which will be a long time

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center