Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

PowerExchange Express CDC for Oracle Supports Oracle Index-Organized Tables

PowerExchange Express CDC for Oracle Supports Oracle Index-Organized Tables

Effective in PowerExchange 10.0, PowerExchange Express CDC for Oracle can capture change data from Oracle index-organized tables (IOTs).
To capture change data from IOTs, you must grant the following privileges to the Oracle user that you defined for CDC:
GRANT SELECT on "SYS"."IND$" TO "ORACAPTL"; GRANT SELECT ON "SYS"."INDPART$" TO "ORACAPTL";
In these statements, "ORACAPTL" is the name of the CDC user.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.

0 COMMENTS

We’d like to hear from you!