CDC Guide for Linux, UNIX, and Windows

10.2
- 10.2.2
- 10.2.1
- 10.0

Back Next

Stopping Oracle CDC with LogMiner Processing for a Table

If you no longer need to capture change data for a table, you can stop change data capture for the table by modifying its capture registration status.

In the PowerExchange Navigator, open the capture registration for the table and change the

Status

option from

Active

History

This option permanently deactivates the registration and stops all change data capture based on the registration. You cannot use the registration for change data capture again.

If you use the PowerExchange Logger for Linux, UNIX, and Windows for Oracle CDC, shut down the PowerExchange Logger and then warm start it.

This step refreshes the registration information that the PowerExchange Logger uses.

Drop the supplemental log groups for the tables with the deactivated registrations. Use the following DDL:

ALTER TABLE schema.table_name DROP SUPPLEMENTAL LOG GROUP

Oracle stops recording before- and after-images of the change data for the tables. If you reinstate a supplemental log group later, you must rematerialize the target database.

In PowerCenter, you must also delete or update CDC workflows, as needed, to make sure that no workflow processes the removed tables.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Stopping Oracle CDC with LogMiner Processing for a Table

Stopping Oracle CDC with LogMiner Processing for a Table