How can i choose my tablespace when i create my spatial index with FME 2013 ?
Thank you
Raphael
Question
Oracle spatial Index
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,
under the Writer feature type, go to properties and "Format parameters". You can specify the "Spatial index name" there, try doing it on the form MYSCHEMA.MYINDEXNAME, where MYSCHEMA has the desired index tablespace as default tablespace.
I haven't tested it, but it might / should work...
David
- Participant
Hello David,
Thank you
I've tested your solution but the translation failed
Execution of statement `CREATE INDEX ME_EDS_IDX.TEST_INDEX ON TEST_INDEX2(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX' did not succeed; error was `ORA-28100: schéma de fonction de règle ME_EDS_IDX non valide'.
Bonjour Raph,
are you certain that ME_EDS_IDX is the name of a schema and not a tablespace?
David
- Participant
David,
if I use this sql command my index is ok
CREATE INDEX TEST_INDEX ON TEST_INDEX2(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('tablespace=bdp_idx');
Raphael
Raphael,
If that works, you could also just disable the spatial index on the Writer, then create it manually with your command using an SQLExecutor.
David