My Oracle Support Banner

Error Occurs When Executing SQL For Spatial Index Creation (Doc ID 2757402.1)

Last updated on MAY 26, 2021

Applies to:

Oracle Spatial and Graph - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Spatial index creation fails with below errors

SQL> create index TW21002001_SI0 on DM_TW21002001 (SDO_GEOMETRY) indextype is mdsys.spatial_index
  2 PARAMETERS('
  3 TABLESPACE = DM1002I
  4 INITIAL = 30M
  5 NEXT = 30M
  6 MINEXTENTS = 1
  7 MAXEXTENTS = UNLIMITED
  8 PCTINCREASE = 0
  9 ');
  create index TW21002001_SI0 on DM_TW21002001 (SDO_GEOMETRY) indextype is mdsys.spatial_index
  *
An error occurred on row 1。:
  ORA-29855: An error occurred while executing the ODCIINDEXCREATE routine。
  ORA-13249: Error executing stmt: INSERT INTO MDSYS.SDO_INDEX_METADATA_TABLE
  (SDO_INDEX_OWNER, SDO_INDEX_TYPE, SDO_LEVEL, SDO_NUMTILES, SDO_MAXLEVEL,
  SDO_COMMIT_INTERVAL, SDO_INDEX_TABLE, SDO_INDEX_NAME, SDO_INDEX_PRIMARY,
  SDO_TSNAME, SDO_COLUMN_NAME, SDO_RTREE_HEIGHT, SDO_RTREE_NUM_NODES,
  SDO_RTREE_DIMENSIONALITY, SDO_RTREE_FANOUT, SDO_RTREE_ROOT, SDO_RTREE_SEQ_NAME,
  SDO_TABLESPACE, SDO_INITIAL_EXTENT, SDO_NEXT_EXTENT, SDO_PCTINCREASE,
  SDO_MIN_EXTENTS, SDO_MAX_EXTENTS, SDO_INDEX_DIMS, SDO_LAYER_GTYPE,
  SDO_RTREE_PCTFREE, SDO_PARTITIONED, SDO_INDEX_GEODETIC, SDO_INDEX_STATUS,
  SDO_DML_BATCH_SIZE, SDO_RTREE_ENT_XPND, SDO_TABLE_NAME, SDO_RTREE_READ_ONLY,
  SDO_OPTIMIZED_NODES) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12,
  0, :13, :14, :15, :16, :17, :18, :19, :20, :21, 2147483645, :22, :23, :24, :25,
  'FALSE', 'VALID', :26, :27, :28, :29, 0)
  ORA-13249: Error in Spatial index: insert to metadata failed
  ORA-06512: "MDSYS.SDO_INDEX_METHOD_10I", row 10

Changes

 New 19c installation

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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