My Oracle Support Banner

Unmapped create synonym is propagated when using classic capture (Doc ID 2868055.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.4 and later
Information in this document applies to any platform.

Symptoms

Suppose you have the following setup:

- Source Side

[SQL]

CREATE USER <TABLE_OWNER_USER>  IDENTIFIED BY <PASSWORD>  DEFAULT TABLESPACE <TABLESPACE_NAME1>  TEMPORARY TABLESPACE <TABLESPACE_NAME2>;
grant dba to <TABLE_OWNER_USER> identified by <PASSWORD>;
CREATE USER <SYNONYM_OWNER_USER>  IDENTIFIED BY <PASSWORD>  DEFAULT TABLESPACE <TABLESPACE_NAME1>  TEMPORARY TABLESPACE <TABLESPACE_NAME2>;
grant dba to <SYNONYM_OWNER_USER> identified by <PASSWORD>;

create table TABOWNER.TEST (col1 number, col2 varchar2(200));

[GoldenGate Parameter]

EXTRACT CAP01
USERID <OGG_USER_NAME>, PASSWORD <PASSWORD>
EXTTRAIL ./dirdat/lt
DDL INCLUDE MAPPED OBJNAME <TABLE_OWNER_USER>.<TABLE_NAME>*
TABLE <TABLE_OWNER_USER>.<TABLE_NAME>*;

 

- Target Side

[SQL]

CREATE USER <TABLE_OWNER_USER> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <TABLESPACE_NAME1> TEMPORARY TABLESPACE <TABLESPACE_NAME2>;
grant dba to <TABLE_OWNER_USER> identified by <PASSWORD>;

create table <TABLE_OWNER_USER>.<TABLE_NAME> (col1 number, col2 varchar2(200));

[GoldenGate Parameter]

REPLICAT REP01
USERID <OGG_USER_NAME>, PASSWORD <PASSWORD>
DISCARDFILE ./dirrpt/REP01.DSC, PURGE
MAP <TABLE_OWNER_USER>.<TABLE_NAME>*, TARGET <TABLE_OWNER_USER>.*;

 

At this time, you executed the following DDL on the source side :

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.