Question

Rebuild Spatial Index for Oracle

  • 12 March 2014
  • 1 reply
  • 8 views
J
Rank
Badge +1
  • jimo Participant
  • Participant
  • 126 replies
I am inserting records into an Oracle Spatial table with an existing spatial index. Does Oracle rebuild the spatial index automatically when I do this? If not, how would I rebuild the spatial index with FME?

 

 

Thanks

1 reply

david_r
Rank
Userlevel 4
Hi,

 

 

Oracle Spatial will automatically grow your existing spatial index when you insert new geometries, but it will not rebuild it.

 

 

If you really do need to rebuild it, you must use the ALTER INDEX ... REBUILD command, see here (http://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes004.htm#ADMIN11734) for more details. There is an advanced setting on the ORACLE8I writer called "SQL statement to execute after translation" which would be the good place to put this.

 

 

David

Reply


Community Stats

28,723
Posts
109,511
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.