Oracle spatial Index

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