This discussion is archived
0 Replies Latest reply: May 14, 2012 8:21 AM by amin_adatia RSS

Add/Split Partition and Reuse Storage Definition

amin_adatia Newbie
Currently Being Moderated
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?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points