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