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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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