Loading....

GoldenGate How to handle replication with extra columns on source and target tables

Case A – Additional Column on Target Table In this example the JOBS table on the target database oradb2 has an additional IDENTITY COLUMN called ID SQL> conn demo/oracle@oradb1Connected.SQL> desc jobsName Null? Type—————————————– ——– —————————-JOB_ID NOT NULL VARCHAR2(10)JOB_TITLE NOT NULL VARCHAR2(35)MIN_SALARY NUMBER(6)MAX_SALARY NUMBER(6)SQL> conn demo/oracle@oradb2Connected.SQL> alter table jobs add (ID NUMBER GENERATED ALWAYS AS IDENTITY);Table […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?