This discussion is archived
3 Replies Latest reply: Apr 1, 2013 6:46 AM by yhu RSS

An internal error was encountered in the extensible spatial index

CrackerJack Newbie
Currently Being Moderated
HiAll,

Ran a query on

CREATE TABLE results1 NOLOGGING AS
SELECT a.rowid1 poly_rowid, a.rowid2 point_rowid
FROM TABLE (SDO_JOIN ('PARCEL', 'GEOMETRY', 'ND_TABLE', 'GEOMETRY')) a;

Thsi query ran for 20 hours! and came up with this error An internal error was encountered in the extensible spatial index.


But when you just run teh select statement the results come in seconds...

I am running on 11GR2 and this query was ran on Sql Developer.

Any help is much appreciated.

Edited by: CrackerJack on Mar 31, 2013 2:50 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points