Toad World® Forums

Partitioned indexes

This is probably another enhancement request. I do not see how I can ask Toad to generate a script for a local partitioned table and partitioned indexes where instead of listing all the partitions for the indexes the keyboard LOCAL is specified without listing all the partitions. Is this possible? For example, I want the script for the indexes to look like

CREATE INDEX ESPOTNITZ.IDX_F_DONATION_AGE_AT_DON_NW ON ESPOTNITZ.FACT_DONATION
(DONOR_AGE_AT_DONATION)
TABLESPACE ED_INDEX
LOCAL ;

instead of

CREATE INDEX ESPOTNITZ.IDX_F_DONATION_AGE_AT_DON_NW ON ESPOTNITZ.FACT_DONATION
(DONOR_AGE_AT_DONATION)
TABLESPACE ED_INDEX
LOCAL (
PARTITION PRT_OLD
LOGGING
NOCOMPRESS
TABLESPACE ED_INDEX,
PARTITION PRT_1991
LOGGING
NOCOMPRESS
TABLESPACE ED_INDEX,
...

Good morning, Ed.

Thank you! Just what I was looking for.