Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-13356 error (redundant points), but not because of tolerance (I guess)

140129Apr 22 2003 — edited Apr 24 2003
I get this error 'ora-13356' when validating the spatial column:

SQL> select * from valid; // the result table

VID RESULT
---------- ----------
DONE
213049 13356
213011 13356

and here is the spatial column for these two rows:

SQL> select vid,mbr from mincom_100_vertex
where vid in (select vid from valid);

VID
----------
MBR(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
213011
SDO_GEOMETRY(3003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR
AY(388160.784, 7035000, 0, 388168.39, 7035000, 5.6843E-14))

213049
SDO_GEOMETRY(3003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR
AY(388180.526, 7035000, 0, 388188.543, 7035000, 5.6843E-14))

I set the tolerance of each dimension to 5E-18, so I think it should be enough. Here is the metadata for it:

SQL> select * from user_sdo_geom_metadata;

TABLE_NAME
--------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
DIMINFO(SDO_DIMNAME, SDO_LB, SDO_UB, SDO_TOLERANCE)
--------------------------------------------------------------------------------
SRID
----------
MINCOM_100_VERTEX
MBR
SDO_DIM_ARRAY(SDO_DIM_ELEMENT('x', 388089.552, 388208.042, 5.0000E-18), SDO_DIM_
ELEMENT('y', 7034990.04, 7035109.55, 5.0000E-18), SDO_DIM_ELEMENT('error', 0, 1.
91629541, 5.0000E-18))

So what is the problem?

I can create R-tree index on this column, but I can not query it. I get this error:

ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [SDO_RELATE] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 232
ORA-06512: at line 1

Here is the sql to create the index

create index rtree on verTab (mbr)
indextype is mdsys.spatial_index parameters('sdo_indx_dims=3');

I tried to remove the two rows that oracle spatial thinks having problem, and then create the index and query it. It is ok with the creation, but the query still has the same problem as above.

Can anyone help?






Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2003
Added on Apr 22 2003
3 comments
2,327 views