Oracle DDL generation - index type / tablespace

[Jan Holub]

Dear colleagues,
when designing class representing the Oracle database table I'm trying to define type of an index for this table and tablespace for this index.
So far I've found there's only posibility to define the tablespace for the table but not for it's index. Moreover I've not found any way how to define the type of the index, for example BITMAP.

When I create the table and running the built-in DDL transformation, it looks like this:
CREATE INDEX <INDEX_NAME> ON <SCHEMA_NAME>.<TABLE_NAME> (<COLUMN_NAME [, COLUMN_NAME ,...] ASC) ;

...it's a bit poor. I need something like this:
CREATE <TYPE> INDEX <INDEX_NAME> ON <SCHEMA_NAME>.<TABLE_NAME> (<COLUMN_NAME [, COLUMN_NAME ,...]) TABLESPACE <TBLSPC_NAME>;

...for example:
CREATE BITMAP INDEX I_DW_ZEME_NAZEV ON DWCRU_DW.DW_ZEME (ZEME_NAZEV) TABLESPACE DWCRU_DW_INDX_128K;

Am I missing something or is there any workaround to define the type of the index and the name of tablespace for this index?

Thank you for any suggestion,
Jan.

Jan Holub
IS Department/Development division
Czech National Bank
Na Prikope 28
Prague, Czech Republic

[juhi]

Give Tablespace name as a tagged value for that particular Index Operation (Operations Dialog).