My Oracle Support Banner

ORA-604, ORA-12899 while Dropping Partition Table with XMLTYPE Column and Global Index, after upgrade from 10.2.0 to 11.2.0.2 (Doc ID 1359345.1)

Last updated on SEPTEMBER 16, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Unable to drop partition table with XMLType column, a associated XML Schema and having a global index with "update global indexes" clause:

drop partition .... update global indexes;
ORA-00604: error occured at recursive SQL level 1
ORA-12899: value too large for column "USERNAME"."TABLENAME"."SYS_NC00010$" (actual: 32766, maximum 3748).

Without the "update global indexes" clause, the same drop command succeeds without any errors.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.