Skip to main content
Solved

CREATE INDEX ON ORA_TABLE


perry
Forum|alt.badge.img+2

Hello FME experts,

I create an ORA table with in the format parameters:

- spatial column GEOMETRIE

- create spatial Index YES

- drop existing Index YES

- spatial index name TST_IDX

I also need an index on the attribute ID so I use the SQL statement to Excecute after Translation:

- CREATE INDEX table1_i ON table1 (ID)

This works fine.

Question: How can I create an other index on a different table also with a spatial index.

I put an extra line into the SQL statement as follows:

CREATE INDEX table1_i ON table1 (ID)

 

CREATE INDEX table2_i ON table 2 (ID)

I have used seperations between the lines (; , ' ') but nothing seems to work

error was `ORA-02158:

....

How can I but indexes on different tables after I created an ORA-table?

Best answer by itay

Hi @perry when using multiple SQL statements you need to use de FME  SQL delimiter in the beginning of your statement

FME_SQL_DELIMITER ;

CREATE INDEX table1_i ON table1 (ID); 
CREATE INDEX table2_i ON table 2 (ID)
View original
Did this help you find an answer to your question?

2 replies

itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • Best Answer
  • December 8, 2016

Hi @perry when using multiple SQL statements you need to use de FME  SQL delimiter in the beginning of your statement

FME_SQL_DELIMITER ;

CREATE INDEX table1_i ON table1 (ID); 
CREATE INDEX table2_i ON table 2 (ID)

perry
Forum|alt.badge.img+2
  • Author
  • December 8, 2016
itay wrote:

Hi @perry when using multiple SQL statements you need to use de FME  SQL delimiter in the beginning of your statement

FME_SQL_DELIMITER ;

CREATE INDEX table1_i ON table1 (ID); 
CREATE INDEX table2_i ON table 2 (ID)

Yes it works,Thnks for your quick response.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings