How can i choose my tablespace when i create my spatial index with FME 2013 ?
Thank you
Raphael
Hello,
Page 1 / 1
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
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
I'm sur, ME_EDS_IDX is a tablespace
Raphael
Well, there is your error :-)
You need to specify a SCHEMA.
David
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
Thank you David,
I think I will keep the sqlexecutor
Raphael