Originally posted by wfy
Every time when the new partition is added we must specify the default tablespace for the local indexes otherwise they will be created on the same tablespace as table.
well if you add partitions you have to change the DEFAULT index attribute with the command I mentioned in previous post, after the change you add the partition the new local index will be created in the tablespace you specify for the default attribute, if it's not adding but splitting the partitions you probably have to do the same, change the attribute (splitting I am not sure, havent done it yet but adding definitely works)