1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. PostgreSQL
  5. Understanding What's Supported for PostgreSQL
  6. Supported Objects and Operations for ProtgreSQL
  7. Tables and Views

Tables and Views

Tables to be included for capture and delivery must meet the following requirements and must only include data types listed under Supported PostgreSQL Data Types.

  • Oracle GoldenGate for PostgreSQL supports capture of transactional DML from user tables, and delivery to user tables.

  • Oracle GoldenGate for PostgreSQL supports delivery to partitioned tables.

  • Globalization is supported for object names (table /schema/database/column names) and column data.

Limitations:

  • Oracle GoldenGate for PostgreSQL does not support capture and delivery for views.

  • Oracle GoldenGate for PostgreSQL does not support capture from partitioned tables.