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!

rename sys generated name constraint

TubbySep 23 2020 — edited Sep 24 2020

Just wondering how to deal with a rename of a system generated constraint (sys_*) on source and apply that to the target, or is this not possible and we need to stop the capture and apply the constraint rename to source and target and then restart the capture?

For example, on the source

alter table tubby_test rename constraint sys_abc123 to tubby_constraint;

Is it possible to have the above modification captured on the source and propagated to the target (the tables are in sync for DDL and DML before this occurs).

Source Oracle 11.2.0.4

Target Oracle 19.3

GG version 19.1

Thanks!

Added on Sep 23 2020

#goldengate

0 comments

404 views