CDC Guide for Linux, UNIX, and Windows

10.0
- 10.2.2
- 10.2.1
- 10.2

Back Next

Step 2. Set Up Oracle Minimal Global Supplemental Logging

PowerExchange requires that Oracle use minimal global supplemental logging so that Oracle LogMiner can properly handle chained rows.

To enable minimal global supplemental logging, log in to the Oracle database and execute the following SQL statement:

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
COMMIT;

You can copy this statement from the sample Setup_Minimal_Supplemental_Logging.sql file.

If you do not know whether minimal global supplemental logging is enabled for your database, you can still execute this ALTER statement. The statement has no effect if minimal supplemental logging is already enabled.

If the Oracle database is open when you execute this statement, Oracle waits for in-flight transactions to complete, which can affect database performance. This issue is likely to occur for databases that have a high level of user activity. To avoid this problem, you can close and re-open the database and then issue the statement manually.

You must also define a supplemental log group for each Oracle source table to cause Oracle to log full before- and after-images of the data that changed. When you register an Oracle table in the PowerExchange Navigator, PowerExchange generates DDL that adds a supplemental log group for the table.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Step 2. Set Up Oracle Minimal Global Supplemental Logging

Step 2. Set Up Oracle Minimal Global Supplemental Logging