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,
...
