HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Adding subpartitions to existing partitioned table

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
subpartitionsaddingexistingpartitionedtable

Problem

In Oracle 11g, is there a way to introduce subpartitions into an existing partitioned table?

I cannot seem to find a combination of EXCHANGE and SPLIT partition that does the right thing. SPLIT will split a partition into multiple partitions, not introduce subpartitions. Any suggestions?

I did find an existing post on partitioning an existing non-partitioned table by exchanging to a table with one partition and then using SPLIT, but can't figure out the equivalent process for subpartitions.

Solution

A new subpartition can be added to the existing partitioned table using the following command:

ALTER TABLE PART_TEST
modify partition OCT19 
add subpartition OCT19AXCS 
values ('AXCS');

Code Snippets

ALTER TABLE PART_TEST
modify partition OCT19 
add subpartition OCT19AXCS 
values ('AXCS');

Context

StackExchange Database Administrators Q#52423, answer score: 6

Revisions (0)

No revisions yet.