My Oracle Support Banner

Change Data Capture(CDC) FAQ (Doc ID 867602.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
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 Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

Reader should be aware of concepts of Streams replication and CDC.The purpose of this document is to answer some frequently asked queries for Change Data Capture.

Questions and Answers

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
Purpose
Questions and Answers
 How to check whether CDC is being used ?
 Can CDC work without setting GLOBAL_NAMES to TRUE?
 Can we setup Asynchronous HotLog Configuration on a 9.2.0.8 database orOracle10g and above is definitely required?
 Is modifying CDC setup using Streams API's supported?
 Is it supported to have Async CDC on a Replica process created by Streams? (ie streams apply) ?
 Should CDC be installed to standby database as same as the primary one?
 Can I use oraclecdc for data  auditing?
 Are there best practices or recommendations on how to handle such a security breach? Has CDC configured properly from security point of view?
 Does Oracle Applications use Change Data Capture (CDC) functionality from the database?Will anything happen toOracleApplications 11i if CDC functionality is disabled?
  Does CDC support the usage of MVIEW as a source table ?
 Can CDC be configured with having a logical standby database  in parallel ?
 Does logical Standby needs to run in Archive mode when CDC is setup or does it use Archive logs shipped from primary ?
 Can one publish change tables on remote database with CDC setup ?
 What are the Steps to add tables to an existing CDC structure?
  How to add columns to a subscription
  What are the steps to modify structures of a CDC table already setup?
 Can we change the names of the control columns to our naming standards? 
 Does the staging database have to have the same value for the compatible parameter as the staging database? e.g. source database compatible parameter is set to 10.2.0 then should it be same at staging database OR it could be different like 10.2.0.1.0
  Can we have additional columns that are not in the source tables and default  to some character?
 Is there any documentation that defines the various extra_column options?  
   
References

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