Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Oracle Multitenant Pluggable Databases as Sources

Oracle Multitenant Pluggable Databases as Sources

Oracle 12
c
introduced multitenant container databases. If you have an Oracle version that supports the Oracle Multitenant option, you can use PowerExchange Express CDC for Oracle to capture change data for source tables that reside in a pluggable database (PDB) within a multitenant container database (CDB).
The following CDC considerations apply to Oracle multitenant environments:
  • PowerExchange Express CDC can capture change data for only a single PDB within a CDB at a time. If you want to capture change data for another PDB in the same CDB, you must configure a separate CDC environment. Informatica recommends that each CDC environment use a unique Oracle capture user ID, pwxorad.cfg file, PowerExchange Logger for Linux, UNIX, and Windows instance and pwxccl.cfg file, and capture registrations.
  • If you move or clone the PDB for which PowerExchange Express CDC is capturing change data to another CDB, the PowerExchange Logger for Linux, UNIX, and Windows connection to the Oracle database is lost. You must cold start the PowerExchange Logger to prevent loss of change data.

0 COMMENTS

We’d like to hear from you!