Ora-600 [17012] On Add/Drop Constraint

(Doc ID 315231.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.2
This problem can occur on any platform.

Symptoms

ORA-600 [17012] creating constraint and dropping same constraint in same sql statement.


SQL>  alter table test
  2  add (constraint test_constraint primary key (a, b))
  3  drop constraint test_constraint cascade;
 alter table test
*
ERROR at line 1:
ORA-600: internal error code, arguments: [17012], [0x60B491D4], [], [], [],
[], [], []

Changes

The failing statement was possible generated from Oracle Enterprise Manager.

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