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
rjdevries
Messages: 1
Registered: February 2006
Junior Member
Hi,

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.
Bart.


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.

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


Current Time: Tue Sep 30 07:42:56 CDT 2014

Total time taken to generate the page: 0.06132 seconds