Query With Supplemental Logging Dealing With UNUSED Columns (Doc ID 2111331.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.10 and later
Information in this document applies to any platform.

Goal

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;
 

Solution

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