Skip to main content
  • EN
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
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

30,108
Posts
114,290
Replies
37,743
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.