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