| ORA-13226 Using Spatial operator [message #157321] |
Wed, 01 February 2006 10:03  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
