3 Replies Latest reply: Apr 1, 2013 8:46 AM by Ying Hu-Oracle RSS

    An internal error was encountered in the extensible spatial index

    CrackerJack
      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