Split maxvalue subpartition into multiple subpartitions
Hi Team
I wrote a procedure to split DEFAULT subpartition of LIST type into multiple subpartitions under each partition of a table.
It's throwing following error when I execute the procedure :
SQL> @call200
---------------------------------------------------------------------
Partition Name : TS201602
---------------------------------------------------------------------
Missing Subpartition Name : 1000
Missing Subpartition Name : 2000
Missing Subpartition Name : 800
Missing Subpartition Name : 900
Populated SQL is : ALTER TABLE PD.TESTING SPLIT SUBPARTITION
TS201602_OTHERS INTO (SUBPARTITION TS201602_1000 VALUES (1000) TABLESPACE
PDFACT_T_FY16T2,SUBPARTITION TS201602_2000 VALUES (2000) TABLESPACE
PDFACT_T_FY16T2,SUBPARTITION TS201602_800 VALUES (800) TABLESPACE
PDFACT_T_FY16T2,SUBPARTITION TS201602_900 VALUES (900) TABLESPACE
PDFACT_T_FY16T2, SUBPARTITION TS201602_OTHERS ) ;
BEGIN split_list_subparts ('PD','TESTING','TS','201602','201605',false, 'LI'); E