DDL Index generation in seperate tablespace

[jason morgan]

Does anyone know if it's possible to assign an index to a different database tablespace than that of the table? It can be done by editing the generated ddl but this will get over-written when the ddl is re-generated.

[«Midnight»]

Hi Jason,

I think you can do this, at least in Oracle. Whether the same trick will work for another DBMS is something you'll have to test on your own.

In the EA help index look up Oracle | Tables, Set Properties. There is a list of properties at the bottom. Note that these can be applied to indexes and constraints. Of course this would depend on Oracle (or your chosen DBMS) providing support for the appropriate property.

HTH, David

[jason morgan]

Thanks David,

Just what I needed..