Change Data Capture(CDC) FAQ
(Doc ID 867602.1)
Last updated on SEPTEMBER 04, 2024
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? |
| 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 |