OraFAQ Forum: Spatial » interface not supported without a spatial index

Home » Server Options » Spatial » interface not supported without a spatial index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

interface not supported without a spatial index [message #124096]

Thu, 16 June 2005 07:22

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.

Report message to a moderator

Re: interface not supported without a spatial index [message #124100 is a reply to message #124096]

Thu, 16 June 2005 07:39

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

Create a spatial index on your geometry table -

Code: [Select all] [Show/ hide]

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:

Code: [Select all] [Show/ hide]

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

Best regards.

Frank

Report message to a moderator

Re: interface not supported without a spatial index [message #124102 is a reply to message #124100]

Thu, 16 June 2005 07:41

linani
Messages: 4
Registered: June 2005

Junior Member

I have created all spatials indexes, but i stil have the same errors.

regards,
lin

Report message to a moderator

Re: interface not supported without a spatial index [message #124106 is a reply to message #124102]

Thu, 16 June 2005 07:53

Frank Naude
Messages: 4596
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

Report message to a moderator

Re: interface not supported without a spatial index [message #124109 is a reply to message #124096]

Thu, 16 June 2005 08:05

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

Report message to a moderator

Re: interface not supported without a spatial index [message #124116 is a reply to message #124109]

Thu, 16 June 2005 08:35

Frank Naude
Messages: 4596
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

Report message to a moderator

Re: interface not supported without a spatial index [message #124122 is a reply to message #124096]

Thu, 16 June 2005 08:54

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

Report message to a moderator

Re: interface not supported without a spatial index [message #124616 is a reply to message #124122]

Mon, 20 June 2005 09:01

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Consider logging an Oracle TAR for this, and let us know the outcome once resolved.

Best regards.

Frank

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 10:52:27 CDT 2025