hi,

pando is correct. if you want to specify NEW attributes for any new partitions for a local index, you have to use the ALTER INDEX MODIFY DEFAULT ATTRIBUTES ddl.

ALTER INDEX empx3 MODIFY DEFAULT ATTRIBUTES
STORAGE ( NEXT 100K ) TABLESPACE empx2_ts;

after that, when you add or split a partitioned table, the local indexes that are subsequently created will implement those new attributes.

nick