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

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.

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

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

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