My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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>"


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".


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.