Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2017

Added on Apr 4 2017

#general-database-discussions, #list

2 comments

1,744 views