Getting ORA-31495 When Attempting A Dml On A Regular Table (Doc ID 1167495.1)

Last updated on MAY 21, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

All suddenly you start seeing following error when attempting to do any DML (Insert/Update/Delete) in a regular database user table:

ORA-31495: error in synchronous change table on "<OWNER>"."<TABLE_NAME>"

Changes

The affected database previously was a source database for a CDC (Change Data Capture) setup.

Note: If the table is still part of a CDC setup, this might be a different issue, please take a look on this another Note 751452.1 "Ora-31495: Error In Synchronous Change Table".

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms