My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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

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