Query With Supplemental Logging Dealing With UNUSED Columns
Last updated on JANUARY 05, 2017
Applies to:Oracle GoldenGate - Version 184.108.40.206.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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms