CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Oracle Data Sources

PowerExchange Express CDC for Oracle captures change data from Oracle sources. Informatica strongly recommends that you use it with the PowerExchange Logger for Linux, UNIX, and Windows.

The following table identifies how PowerExchange Express CDC supports selected Oracle features:

Feature	PowerExchange Express CDC for Oracle Support
PowerExchange Logger for Linux, UNIX, and Windows use	Use of the PowerExchange Logger is strongly recommended
Multithreaded processing	Yes
CDC processing speed	Fast
Oracle redo logs processing	Reads change data directly from active logs and from archived redo logs, including copies of the archived logs that were created outside of the Oracle archive process.
Oracle data dictionary use	Transparently stores the data dictionary in memory.
Checkpointing	Periodically writes state information for in-flight transactions to tables or file-system files for checkpointing.
Capture from Oracle RAC and ASM environments	Yes
Capture from Oracle Data Guard environments	Can capture data from Data Guard logical and physical standby databases.
Capture from Oracle multitenant environments	Can capture data from a single pluggable database (PDB)
Capture from Amazon Elastic Compute Cloud (EC2) and Amazon RDS for Oracle environments	Yes
Capture from Oracle Exadata machines	Yes
Capture from tables that use Oracle Exadata Hybrid Columnar Compression (EHCC)	Yes, except direct-path operations.
Capture from objects that use Oracle Advanced Security Transparent Data Encryption (TDE)	Can capture data from encrypted tablespaces but not from encrypted columns.
Capture from objects that use Oracle Advanced Compression	Can capture conventional and direct-path DML operations from tables and table partitions and subpartitions that use Advanced Compression.
Direct-path operations	Can capture direct-path operations except for tables that use EHCC.
DDL operations	Does not capture CREATE TABLE…AS SELECT operations because the table cannot be registered for CDC. Tolerates ALTER TABLE ADD, ALTER TABLE ADD PARTITION, ALTER TABLE ADD CONSTRAINT, CREATE USER, ALTER USER, and DROP USER operations. The DDL change is not captured but CDC processing of other changes continues.
Oracle RESETLOGS events	Can capture data across a RESETLOGS boundary in the archive logs.
EXCHANGE PARTITION operations	Does not capture the exchange operation or any rows it generates. Can capture subsequent DML changes on the table or partition that was the target of the exchange, if registered for CDC.
Source data loaded with the SQL*Loader utility	Can capture the data if the utility load type is conventional path and the load method is Insert, with the exception of data that is compressed with EHCC.
Capture from index-organized tables (IOTs)	Yes
Capture from materialized views	Can capture data from the master tables that underlie the views.
Capture from tables that use system partitioning or reference partitioning	Yes
Capture from tables in a sorted hash cluster	No
Capture from virtual columns with derived data	No
Capture from LOB columns	Available shortly after the PowerExchange 10.5 release