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


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

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