We can simply add and drop partitions from table as we are dropping and creating a new table. While dropping and adding table partition , we need to take care of the index too. In previous post we saw simply removing partitions makes index unusable. For Reference Drop Table Partition without Index Maintenance and SKIP_UNUSABLE_INDEXES […]
Articles Tagged: drop partition
Drop Table Partition without Index Maintenance and SKIP_UNUSABLE_INDEXES parameter
In this article we will see how we can drop the PARTITION without any index maintenance at run time and doing it later. I have following partitions available for my table TRANSACTIONS_NEW. I have one index on it on date_of_transaction column : Let us drop partition Y_2014 Let us check index status : We can […]
Dropping Table and Index Partition
Dropping Table partition or Index partition is a part of routine maintenance job of DBA. When to drop or add partition ? Well, it depends on the requirement . For instance , in range partitioned tables whenever new range comes in the picture we need to add new partition for the table if we have […]