My Oracle Support Banner

Common Questions About Dropping/Truncating Partition (Doc ID 1483661.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 24-10-2012***

Goal

 This document addresses the best practices and methods for drop partition.

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
 Dropping Partitions
 Dropping Table Partitions
 Dropping a Partition from a Table that Contains Data and Global Indexes
 Dropping a Partition Containing Data and Referential Integrity Constraints
 Dropping Interval Partitions
 Dropping Index Partitions
 
 Truncating Partitions
 Truncating Table Partitions Containing Data and Global Indexes
 Truncating a Partition Containing Data and Referential Integrity Constraints
 Truncating a Subpartition
 How to alter/drop maxvalued table partitioned?
 How to Drop Partitioned Tables
 Updating Indexes Automatically
 Dropping/Truncating partitions in 12c
References

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