I have a table which is partitioned on Date and Data_Source. Each Data Source partitions go into their own tablespace. When a new partition is added, I get a new Storage definition created. What I want to be able to do is to be able to re-use a specific storage based on the Data_Source. After the partition is added I do an ALTER INDEX REBUILD PARTITION PARAMETERS('REPLACE STORAGE <Data_Source_Storage>')
Can I then drop the automatically created storage which has the <Index_Name_Snnnn> name? OR better how to avoid getting the Snnnn storage definitions from getting created?