Skip to Main Content

Split List partition of default partition

Siva OraApr 4 2017 — edited Apr 4 2017

Hello,

Please let me know if we can split the List partition created only with default partition.

Will there be any impact to the base table, index or dependant objects?

Can we split the table parttition duringĀ  online of the database?

Do we nned any maintenance window to perform this split partition?

ALTER TABLE "REGUSR"."AR_ATTS_DATA"
SPLIT PARTITION "AR_ATTS_DATA_DFLT_PART" VALUES ('Y','y')
INTO (PARTITION "AR_ATTS_DATA_DFLT_PART",
PARTITION
"AR_ATTS_DATA_DFLT_PART_2") UPDATE INDEXES

Comments
Post Details
Added on Apr 4 2017
2 comments
1,399 views