ORA-60019 When Creating Table With XmlType Column (Doc ID 1274587.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2016***

Symptoms

Encounter this issue when creating a table with XMLTYPE column
(Note: Issue occurs in 11.2.0.2 but not in 11.2.0.1)

create tablespace odb_index
datafile '/grdbms/64bit/app/oracle/oradata/S112W6/odb01.dbf' size 100M
extent management local uniform size 80K
segment space management auto;

Tablespace created.

create table EDIK ( ORDER_ID NUMBER(28) not null, ORDER_DATA SYS.XMLTYPE)
tablespace odb_index;

create table EDIK ( ORDER_ID NUMBER(28) not null, ORDER_DATA SYS.XMLTYPE)
tablespace odb_index
*
ERROR at line 1:
ORA-60019: Creating initial extent of size 10 in tablespace of extent size 14


The issue does not occur when the tablespace is defined as follows:


create tablespace ODB_INDEX
datafile '/hds/xb01/oradata/r11g_tst/odb_index_01.dbf' size 100M
extent management local uniform size 120K
segment space management auto;

Tablespace created.

create table edik_hdb.EDIK (ORDER_ID NUMBER(28) not null,  ORDER_DATA SYS.XMLTYPE) 
tablespace odb_index;

Table created.

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