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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Golden gate colsexcept

RobeenApr 4 2019 — edited Apr 5 2019

Oracle Database 18c(target)

Oracle Database 12.1.0.2 source

RHEL 7.4

Hello Team,

I am planning to setup a filtering such that XML fields will be omitted

2019-04-04T15:09:16.677+0400  ERROR   OGG-01169  Oracle GoldenGate Delivery for Oracle, dwarer.prm:  Encountered an update where all key columns for target table CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER are not present.

Schema replication is enabled

EXTRACT ECBS

--- User login

USERIDALIAS extractogg

DISCARDFILE ./dirrpt/eapps.dsc, APPEND

DISCARDROLLOVER AT 01:00 ON SUNDAY

EXTTRAIL ./dirdat/et

STATOPTIONS REPORTFETCH

REPORTCOUNT every 10 minutes, RATE

LOGALLSUPCOLS

REPORTROLLOVER AT 01:00 ON SUNDAY

--- DDL Parameters

UPDATERECORDFORMAT COMPACT

TRANLOGOPTIONS INCLUDEREGIONID

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

TABLE CBS_CUST.* ;

EXTRACT extpump

RMTHOST RH-***, MGRPORT 7***

--RMTHOSTOPTIONS ENCRYPT AES192, KEYNAME securekey2

RMTTRAIL /u01/app/OGG/dirdat/rt

PASSTHRU

TABLE CBS_CUST.*;

Should I remove the PASSTHRU in the pump parameter file and include

CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER COLSEXCEPT (REQUEST_XML); ?

Thanks,

Joe

Comments

Veera-Oracle Apr 4 2019

Hi Joe,

COLSEXCEPT should be used in the Extract parameter file.

Please check the below link,

http://www.oracle-scn.com/cols-and-colsexcept-in-oracle-goldengate/

Regards,

Veera

Robeen Apr 4 2019

Error is gone when I inserted a Primary Key in the table. On source, the primary key existed.

Robeen Apr 5 2019

Hello,

I have tested the replication from a 12.1 database to an 18c database.

I would like to know if the replication will be successful with a target 12.2 database or if there will be some restrictions. Then I will need to test on a 12.2.0 database.

Thanks and Regards,

Joe

1 - 3

Post Details

Added on Apr 4 2019
3 comments
874 views