Skip to Main Content
Forums

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

Paavo

Hi
Copy-pasting large snippets sounds like you could benefit of using editor instead?
It is possible to define editors like: emacs, vi, visual studio code.
For vcode:
--open terminal in vcode and use sqlcl and e file.sql and / commands and enjoy
define _EDITOR=code -w -r
rgrds Paavo
ps. have a look on @thatjeffsmith-oracle blogs e.g. http://www.thatjeffsmith.com/archive/2016/05/multiple-ways-to-edit-in-sqlcl/

AboMohammed

Thanks for your response.

I will definitely try it.

1 - 2

Post Details

Added on Jul 28 2020
#11g, #goldengate, #oracle
3 comments
1,073 views