Skip to Main Content

GoldenGate Free

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!

How to add trandata in OGG 23ai having source database as IBM DB2 for i database

Sohan AshtamkarDec 4 2025

Hi Team,

I have an on-premise remote ogg 23ai setup. My source database is IBM DB2 for i database. My target database is Oracle 19c database. I have completed INITIAL LOAD for my tables from source to target. I want to now start my CDC extract. FYI, I have setup the journaling at the library level at source database side which is having all the tables. since the journaling is set, later, I verified, the trandata is visible from golden gate UI as well. however I by mistakenly deleted the trandata for 1 of the table from the golden gate UI. When I am trying to re-add it from golden gate UI using the Add Trandata option, I am not able to add it. I tried giving Table Name: YCRPDTA.FCW06 Journal: YCRPDTA/DJ010A

Need support on:

I know the journal details associated to my library.table, how to add the trandata from OGG 23ai UI Screen below. what wrong am I entering in the required fields in the below screenshot ?

Before:

Tried below: When submitted, it says in the top right notification, check whether the specified library exists in the database for the table.

Comments
Post Details
Added on Dec 4 2025
0 comments
37 views