Skip to Main Content

GoldenGate

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!

Golden Gate replication in same database

1527755Jul 28 2020 — edited Jul 29 2020

Is it possible to replicate data between two schemas of same Oracle database through golden gate? We are trying to avoid having to query on source schema directly in order not to overwhelm source tables and there is a plan in future to move target schema to a separate database.

This post has been answered by ORASCN on Jul 28 2020
Jump to Answer

Comments

ORASCN
Answer

Yes, this is possible. You can replicat data between two schemas of same database using OGG.

Regards,

Veera

Marked as Answer by 1527755 · Sep 27 2020
Sreesha Nair-Oracle

Hi,

Yes, it is possible.

All you would need to do is in the extract parameter file add

TABLE schema1.* ------> if you want to replicate entire schema

TABLE schema1.table1 ----> If you want to replicate specific table

And at replicat end, add below parameter

MAP schema1.*, TARGET schema2.*; ----> for entire schema

MAP schema1.table1, TARGET schema2.table2;---> for individual table replication

1527755

Thanks for the quick response

1 - 3

Post Details

Added on Jul 28 2020
3 comments
1,009 views