Thanks
Question
Rebuild Spatial Index for Oracle
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?
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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.