Thursday, March 19, 2015

Oracle Change Data Capture (CDC) Apply encountered ORA-54013

This issue is raised on 11g when a function based index is created on the CDC's schema change set's change table.

Then a transaction against this table (Insert, update, delete) will not apply the change and will fail with ORA-54013: INSERT operation disallowed on virtual columns
recorder on the DBA_APPLY_ERROR table.

Work around is to drop the function based index from the change table, restart capture and apply process and then re-execute the failed transactions errors.

As sys execute : dbms_apply_adm.execute_all_errors;

REFERENCES: Oracle Support Doc ID 1555572.1

2 comments:

  1. It's nice blog for oracle updates , Anantha.co.uk, one of the UK's leading technology Oracle recruitment agencies.Feel free, contact to us now.

    ReplyDelete
  2. Very informative feature indeed, i have come across a similar solution at an ERP Job Board

    ReplyDelete