Index creation problems

From: Jayesh Govindarajan <jayesh_at_praja.com>
Date: Mon, 1 Nov 1999 10:05:37 -0800
Message-ID: <7vkkqc$2s6o$1@thoth.cts.com>

Hi ! All

while playing around with the Oracle Spatial cartridge i encountered some problems.

The problem i encounter is when i try to create an index for the spatial datatype column.

 I was wondering if somone could point me in the right direction.

Here is the errors i get
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13200: internal error [ROWID:AAAC+NAABAAAFEDAAF] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13192: failed to read number of element rows
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7
ORA-06512: at line 1

ORA-13192 err details in the documentation asks me to contact cust support.

And here is what I have created -

2 Tables - named poly and SDO_GEOM_METADATA

SQL> describe poly

 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------


------------------------


 GID                                                            VARCHAR2(30)

 GEOMETRY
MDSYS.SDO_GEOMETRY SQL> describe SDO_GEOM_METADATA

 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------


------------------------


 TABLE_NAME                                                     VARCHAR2(30)
 COLUMN_NAME                                                    VARCHAR2(30)

 DIMINFO
MDSYS.SDO_DIM_ARRAY Now, when i try to create an index on the table poly here is the problem i encounter

SQL> CREATE INDEX poly_FIXED ON poly(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX
  2 PARAMETERS('SDO_LEVEL = 4');
 CREATE INDEX poly_FIXED ON poly(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX *

Here is when if spews the errors i mention earlier.

Could someone let me know if i am missing something here ?

THanks

Jayesh Received on Mon Nov 01 1999 - 12:05:37 CST