My Oracle Support Banner

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

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.