Re-starting Journal Drops All J$ Tables in Consistent Set
(Doc ID 2690385.1)
Last updated on JULY 20, 2020
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
When adding a model to an existing (Changed Data Capture) CDC Consistent Set Journalization with knowledge module "JKM Oracle to Oracle Consistent (OGG Online)" on Oracle Data Integrator (ODI) 126.96.36.199.0, all the existing J$ tables are dropped after the Journal "restart".
This behavior contradicts the ODI documentation where it is indicated that the Consistent Set JKMs support restarting the journals without losing any data.
Developing Integration Projects with Oracle Data Integrator
Setting up and Starting Journalizing
In the section 'Start/Drop the journals' the following is mentioned:
"Note: Dropping the journals deletes all captured changes as well as the infrastructure. For simple journalizing, starting the journal in addition deletes the journal contents. Consistent Set JKMs support restarting the journals without losing any data."
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