Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REMAP_SCHEMA

KrishnaAug 30 2012 — edited Aug 31 2012

Hello All,

Greetings !

I have 2 identical schema with data differences. I need to remove the this differences for i am supposed to implement continuous replication, in that case both schema must be in sync.

If i export schema using data pump expdp, my question is when i import with REMAP_SCHEMA, what exactly will be the internal process..

1. will it recreate the schema ?
2. all the tables and object in it will overridden or appended ?
3. what about the dependent object of other schema ?

Please guide me through...

Kind Regards,
Krishna.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2012

Added on Aug 30 2012

#database-key-features, #export-import-sql-loader-external-tables

7 comments

1,118 views