My Oracle Support Banner

Tips for drop partition operation (Doc ID 1489462.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Goal

 To provide the common practices for the drop partition operation

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
  What are the recommended steps to follow when one or many partitions need to be dropped?
 Option 1:
 Option 2 more appropriate if the partitions dropped contains a significant percentage of of the total data in the table:
 Option 3
 Option 4
  What need to be considered about reclaiming the diskspace?
 What is the reason for which in the index the space released from the deleted partitions has not been re-used, at least not efficiently?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.