Home » Server Options » Spatial » ORA-13226 Using Spatial operator
ORA-13226 Using Spatial operator [message #157321] Wed, 01 February 2006 10:03 Go to next message
Messages: 1
Registered: February 2006
Junior Member

I am doing the following query:

select *
from leiding
where sdo_relate((select werk_ligging from leiding where id=18236829),(select werk_ligging from leiding where id=18236655),'mask=touch') = 'true'

This gives me error ORA-13266: Interface not supported without a spatial index.

Leiding is a view.
The underlying table that contains the sdo_geometry has a spatial index though.

Similar queries against other views (other db) work fine...

Could the size of the underlying table cause problems?

Any suggestions about what is wrong?

Thanks a lot.

Re: ORA-13226 Using Spatial operator [message #231579 is a reply to message #157321] Tue, 17 April 2007 10:29 Go to previous message
Prasad Swarna
Messages: 4
Registered: May 2002
Junior Member
I am getting the same error. The spatial index has been created, but still I get "ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 58"

Did you find any resolution to your problem?
THanks for your help.

Previous Topic: SDO_GEOM_METADATA table missing
Next Topic: AutoCAD MAP 3D - Oracle SDO
Goto Forum:

Current Time: Fri May 07 16:45:16 CDT 2021