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 … Continue reading Drop Table Partition without Index Maintenance and SKIP_UNUSABLE_INDEXES parameter