My Oracle Support Banner

How To Disable And Drop Change Data Capture (CDC) Objects? (Doc ID 734214.1)

Last updated on JANUARY 11, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform. Oracle Server Enterprise Edition - Version: to
*** ***


Change Data Capture utilizes the Streams component of the RDBMS. Most specifically Asynchronous Change Data Capture is built on, and provides a relational interface to, Oracle Streams. It is often misunderstood the steps to disable and stop the Change Capture Processes within Oracle10g. This note will help the reader understand the SQL necessary to properly disable and drop Change Data Capture Asynchronous components.

Synchronous change sets are always created enabled and cannot be disabled. The predefinied SYNC_SET for synchronous change cannot be altered or dropped. For synchronous change data triggers on the source database allow change data to be captured immediately, as each SQL statement that performs a data manipulation language (DML) operation (INSERT, UPDATE, or DELETE) is made.

NOTE  The database links must exist when creating, altering or dropping Distributed HotLog change sources, change sets and change tables.

NOTE  If a subscriber wishes to drop a subscription only  using DBMS_CDC_SUBSCRIBE.DROP_SUBSCRIPTION in order to end a subscription, it is not necessary to disable CHANGE_SET.


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

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