For example like
CREATE INDEX bar_si ON foo(geometry)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('layer_gtype=POINT')
Thanks,
Yola
Question
Oracle Writer Spatial Index Parameters
+1- Contributor
I'm using FME Desktop 2013 and writing to a new table with the Oracle SpatialWriter . Is there any way to use the parameters clause for the spatial index creation statement? I'd like to specify a layer_gtype for my spatial indexes.
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.
+21- Contributor
Are you able to make use of the Advanced Parameter that can run after the translation, found on the writer? Instead of using the dedicated indexing parameters...
+26- Contributor
I never use the SQL parameters in FME to create the Spatial index on an Oracle table.
To control what you need to do I would create the Metadata before and the Spatial index after inserting the data into the table using SQL scripts or statements in a SQL application (SQLDeveloper, SQL*Plus or Toad). If you need to reload a big table, dropping the Spatial index before inserting and recreating it after inserting the data will boost your performance.
Creating the Metadata before inserting will allow you to add a SRID to the geometry as FME reads the Metadata to define the SRID.