How To Disable And Drop Change Data Capture (CDC) Objects in 11g

(Doc ID 1320951.1)

Last updated on JULY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

Change Data Capture utilizes the Streams component of the RDBMS. It is often misunderstood the steps to disable and stop the Change Capture Processes within Oracle11g. This note will help the reader understand the SQL necessary to properly disable and drop Change Data Capture Distributed Hotlog


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.

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