Question

Oracle spatial Index

  • 11 July 2013
  • 8 replies
  • 12 views
R
Hello,

 

 

How can i choose my tablespace when i create my spatial index with FME 2013 ?

 

 

Thank you

 

 

Raphael

8 replies

david_r
Rank
Userlevel 4
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
R
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'.
david_r
Rank
Userlevel 4
Bonjour Raph,

 

 

are you certain that ME_EDS_IDX is the name of a schema and not a tablespace?

 

 

David
R
I'm sur, ME_EDS_IDX is a tablespace

 

 

Raphael
david_r
Rank
Userlevel 4
Well, there is your error :-)

 

 

You need to specify a SCHEMA.

 

 

David
R
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

 

david_r
Rank
Userlevel 4
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
R
Thank you David,

 

 

I think I will keep the sqlexecutor

 

 

Raphael

Reply


Community Stats

28,731
Posts
109,529
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.