After Executing ulg.sql As Part Of The OGG Upgrade, ALL COLUMN LOGGING is Shown in dba_log_groups
(Doc ID 2859761.1)
Last updated on JULY 18, 2023
Applies to:Oracle GoldenGate - Version 22.214.171.124.4 and later
Information in this document applies to any platform.
As per our upgrade guides during ogg upgrade we need to run ulg.sql.
Initially have a OGG v18.x(or lower) and then enabled trandata . Now when upgrading to
19.1.x, we need to execute ulg.sql and after that it will show "ALL COLUMN LOGGING"
SQL> select * from dba_log_groups where OWNER='<SCHEMA NAME' and TABLE_NAME='<Table Name>';
ALL COLUMN LOGGING ALWAYS GENERATED NAME
It will still only capture the updated column + the PK but the output shows having ALL column logging.
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