Home » Server Options » Spatial » interface not supported without a spatial index
interface not supported without a spatial index [message #124096] Thu, 16 June 2005 07:22 Go to next message
linani
Messages: 4
Registered: June 2005
Junior Member
hi,

I try to execute a spatial query, but i have these errors:

ERROR at line 1:
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

All index are are created.
Did anyone know how to do to resolve this problem?

thank you for your help.
Re: interface not supported without a spatial index [message #124100 is a reply to message #124096] Thu, 16 June 2005 07:39 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Create a spatial index on your geometry table -

13226, 00000, "interface not supported without a spatial index"
// *Cause: The geometry table does not have a spatial index.
// *Action: Verify that the geometry table referenced in the spatial operator
//           has a spatial index on it.


Example:

CREATE INDEX index_name ON table_name (geom_column_name)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;


Best regards.

Frank
Re: interface not supported without a spatial index [message #124102 is a reply to message #124100] Thu, 16 June 2005 07:41 Go to previous messageGo to next message
linani
Messages: 4
Registered: June 2005
Junior Member
I have created all spatials indexes, but i stil have the same errors.

regards,
lin
Re: interface not supported without a spatial index [message #124106 is a reply to message #124102] Thu, 16 June 2005 07:53 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Well, this error message indicates that Oracle didn't recognize the spatial index. Do you maybe try to access the table via a view? Have you analyzed the spatial index?

Best regards.

Frank
Re: interface not supported without a spatial index [message #124109 is a reply to message #124096] Thu, 16 June 2005 08:05 Go to previous messageGo to next message
linani
Messages: 4
Registered: June 2005
Junior Member
i don't try to access on tables via views.
What should i do for analyze spatial index?

thanks.
lin
Re: interface not supported without a spatial index [message #124116 is a reply to message #124109] Thu, 16 June 2005 08:35 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Please post a simplified version of your query and the output from:

SELECT table_owner, index_name, column_name, column_position FROM user_ind_columns
WHERE ....

Best regards.

Frank
Re: interface not supported without a spatial index [message #124122 is a reply to message #124096] Thu, 16 June 2005 08:54 Go to previous messageGo to next message
linani
Messages: 4
Registered: June 2005
Junior Member
this is my query:

select * from TABLE1 SELF
where not (exists (
((select PK2 from TABLE2)) intersect
select PK2 from TABLE2 T2
where MDSYS.SDO_RELATE(((select GEOMETRIE from TABLE3 where R_PK1 in
(select PK1 from TABLE1 where PK1 = 2)))
, T2.GEOMETRIE
, 'mask=CONTAINS+COVERS querytype=WINDOW')= 'TRUE'
));

geometrics tables are: table2 and table3
Re: interface not supported without a spatial index [message #124616 is a reply to message #124122] Mon, 20 June 2005 09:01 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Consider logging an Oracle TAR for this, and let us know the outcome once resolved.

Best regards.

Frank
Previous Topic: migrating from Informix to Oracle
Next Topic: Importing AutoDeskMap maps into Oracle
Goto Forum:
  


Current Time: Thu Mar 28 17:23:30 CDT 2024