Query With Supplemental Logging Dealing With UNUSED Columns
(Doc ID 2111331.1)
Last updated on JANUARY 05, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.10 and later
Information in this document applies to any platform.
We are using both OGG and STREAMS in our environment. We are frequently dealing with UNUSED columns for certain databases. We add the supplemental using the below command for all the tables. So when dropping the UNUSED columns do we need to drop and re-add the supplemental logging for the table for which we are dropping the UNUSED columns?
ALTER TABLE schemaname.tablename ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
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