Table of Contents

Search

  1. Preface
  2. PWX-10000 to PWX-10999
  3. PWX-11000 to PWX-15999
  4. PWX-16000 to PWX-23999
  5. PWX-25000 to PWX-35999
  6. PWX-36000 to PWX-36999
  7. PWX-37100 to PWX-37999
  8. PWX-38500 to PWX-38999
  9. DTL_BMG003 to DTL_RPS105I
  10. infacmd pwx Error Messages
  11. PWXPC Error Messages
  12. Abend, Return, and Reason Codes in PowerExchange Messages

Message Reference Volume 2

Message Reference Volume 2

PWX- 36323

PWX-
36323

ORAD Warn: Table
creator
.
table_name
has ROW MOVEMENT enabled. ROWID is not available.
A registered Oracle table has row movement enabled. PowerExchange Express CDC for Oracle does not capture ROWID values for the table because row movement can cause the ROWID values to change. This message is issued when the ROWID parameter in the OPTIONS statement of the Express CDC configuration file is set to Y.
PowerExchange capture processing ends if the ROW_MOVEMENT_FAIL parameter in the Express CDC configuration file is set to Y . PowerExchange capture processing continues if the ROW_MOVEMENT_FAIL parameter is set to N. If PowerExchange capture processing continues, null values are written to the DTL__CAPXROWID field of change records.
If the ROWID parameter is set to Y but you want capture processing to continue when PowerExchange encounters a table that has row movement enabled, you can set the ROW_MOVEMENT_FAIL parameter to N or remove the table from the CDC session. If you do not want to PowerExchange to check whether tables have row movement enabled and do not need to capture ROWID values, set the ROWID parameter to N.

0 COMMENTS

We’d like to hear from you!