My Oracle Support Banner

How to Add a Partition/Subpartition & Move a Partition/Subpartition to Different Tablespace (Doc ID 973776.1)

Last updated on AUGUST 14, 2019

Applies to:

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


How to Add a Partition/Subpartition and Move a Partition/Subpartition to another tablespace?


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
 You can add a partition to a table as follows (example for range partition):
 You can add subpartition as below if subpartition template not specified (example for list partition):
 You can move a partition to another tablespace if it is not composite partitioned:
 You can move subpartition to another tablespace using:

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