How To Disable And Drop Change Data Capture (CDC) Objects in 11g
(Doc ID 1320951.1)
Last updated on NOVEMBER 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema 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
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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
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