Hello !
New to Spatial so I am reading a book Pro Oracle Spatial for 11g, old book but I thought
it can help me with the basics. Some data was supplied in old imp dump files, had error doing the import
on the index create part. Tables and data are there, I extracted the sql to build the index and almost all works without error, Just the last one giving an error.
SQL> CREATE INDEX "SPATIAL"."GC_ROAD_SEGMENT_US_SIDX" ON "GC_ROAD_SEGMENT_US"
("GEOMETRY" ) INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;
CREATE INDEX "SPATIAL"."GC_ROAD_SEGMENT_US_SIDX" ON "GC_ROAD_SEGMENT_US"
*
ERROR at line 1:
ORA-29855: error occurred in the execution of 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_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, 'TRUE', 'VALID', :21, :22, :23, :24, 0)
ORA-13249: Error in Spatial index: insert to metadata failed
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
Checked MOS for info but cannot find anything, anyone that can help me with this ?
Br
Magnus Johansson