Create Table With XMLType Column Fails With ORA-00600: [16651] (Doc ID 2435453.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

When attempting to create a table with xmltype, an internal error is raised:

CREATE TABLE <table name>
( id number,
  PERMID NUMBER(38, 0) NOT NULL,
 XML_FRAGMENT SYS.XMLTYPE,
 CREATE_DATE DATE,
 PUBLISH_DATE DATE ,
 PUBLISH_FLAG CHAR(1 BYTE)
)
XMLTYPE XML_FRAGMENT STORE AS OBJECT RELATIONAL XMLSCHEMA "<schema url>" ELEMENT "Quote"
PARTITION BY HASH (PERMID)
PARTITIONS 32
storage(initial 65536)

ERROR
-----------------------
ERROR Found: ORA-00600
ERROR Argument: 16651

Changes

Cause

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