SET CURRENT SQLID = 'S100447'; 00010000
COMMIT; 00020000
00030000
SET CURRENT SQLID = 'S100447'; 00040000
COMMIT; 00050000
00060000
-- ALTER PARTITION 00070000
ALTER TABLE A914227B.TNZ243A1 00080000
ALTER PARTITION 1 00090000
ENDING AT (X'0003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00100000
COMMIT; 00110000
ALTER TABLE A914227B.TNZ243A1 00120000
ALTER PARTITION 2 00130000
ENDING AT (X'0007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00140000
COMMIT; 00150000
ALTER TABLE A914227B.TNZ243A1 00160000
ALTER PARTITION 3 00170000
ENDING AT (X'000BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00180000
COMMIT; 00190000
ALTER TABLE A914227B.TNZ243A1 00200000
ALTER PARTITION 4 00210000
ENDING AT (X'000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00220000
COMMIT; 00230000
ALTER TABLE A914227B.TNZ243A1 00240000
ALTER PARTITION 5 00250000
ENDING AT (X'0013FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00260000
COMMIT; 00270000
ALTER TABLE A914227B.TNZ243A1 00280000
ALTER PARTITION 6 00290000
ENDING AT (X'0017FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00300000
COMMIT; 00310000
ALTER TABLE A914227B.TNZ243A1 00320000
ALTER PARTITION 7 00330000
ENDING AT (X'001BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00340000
COMMIT; 00350000
ALTER TABLE A914227B.TNZ243A1 00360000
ALTER PARTITION 8 00370000
ENDING AT (X'001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00380000
COMMIT; 00390000
ALTER TABLE A914227B.TNZ243A1 00400000
ALTER PARTITION 9 00410000
ENDING AT (X'0023FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00420000
COMMIT; 00430000
ALTER TABLE A914227B.TNZ243A1 00440000
ALTER PARTITION 10 00450000
ENDING AT (X'0027FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00460000
COMMIT; 00470000
ALTER TABLE A914227B.TNZ243A1 00480000
ALTER PARTITION 11 00490000
ENDING AT (X'002BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00500000
COMMIT; 00510000
ALTER TABLE A914227B.TNZ243A1 00520000
ALTER PARTITION 12 00530000
ENDING AT (X'002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00540000
COMMIT; 00550000
ALTER TABLE A914227B.TNZ243A1 00560000
ALTER PARTITION 13 00570000
ENDING AT (X'0033FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00580000
COMMIT; 00590000
ALTER TABLE A914227B.TNZ243A1 00600000
ALTER PARTITION 14 00610000
ENDING AT (X'0037FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00620000
COMMIT; 00630000
ALTER TABLE A914227B.TNZ243A1 00640000
ALTER PARTITION 15 00650000
ENDING AT (X'003BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00660000
COMMIT; 00670000
ALTER TABLE A914227B.TNZ243A1 00680000
ALTER PARTITION 16 00690000
ENDING AT (X'003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00700000
COMMIT; 00710000
ALTER TABLE A914227B.TNZ243A1 00720000
ALTER PARTITION 17 00730000
ENDING AT (X'0043FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00740000
COMMIT; 00750000
ALTER TABLE A914227B.TNZ243A1 00760000
ALTER PARTITION 18 00770000
ENDING AT (X'0047FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00780000
COMMIT; 00790000
ALTER TABLE A914227B.TNZ243A1 00800000
ALTER PARTITION 19 00810000
ENDING AT (X'004BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00820000
COMMIT; 00830000
ALTER TABLE A914227B.TNZ243A1 00840000
ALTER PARTITION 20 00850000
ENDING AT (X'004FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00860000
COMMIT; 00870000
ALTER TABLE A914227B.TNZ243A1 00880000
ALTER PARTITION 21 00890000
ENDING AT (X'0053FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00900000
COMMIT; 00910000
ALTER TABLE A914227B.TNZ243A1 00920000
ALTER PARTITION 22 00930000
ENDING AT (X'0057FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00940000
COMMIT; 00950000
ALTER TABLE A914227B.TNZ243A1 00960000
ALTER PARTITION 23 00970000
ENDING AT (X'005BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00980000
COMMIT; 00990000
ALTER TABLE A914227B.TNZ243A1 01000000
ALTER PARTITION 24 01010000
ENDING AT (X'005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01020000
COMMIT; 01030000
ALTER TABLE A914227B.TNZ243A1 01040000
ALTER PARTITION 25 01050000
ENDING AT (X'0063FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01060000
COMMIT; 01070000
ALTER TABLE A914227B.TNZ243A1 01080000
ALTER PARTITION 26 01090000
ENDING AT (X'0067FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01100000
COMMIT; 01110000
ALTER TABLE A914227B.TNZ243A1 01120000
ALTER PARTITION 27 01130000
ENDING AT (X'006BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01140000
COMMIT; 01150000
ALTER TABLE A914227B.TNZ243A1 01160000
ALTER PARTITION 28 01170000
ENDING AT (X'006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01180000
COMMIT; 01190000
ALTER TABLE A914227B.TNZ243A1 01200000
ALTER PARTITION 29 01210000
ENDING AT (X'0073FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01220000
COMMIT; 01230000
ALTER TABLE A914227B.TNZ243A1 01240000
ALTER PARTITION 30 01250000
ENDING AT (X'0077FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01260000
COMMIT; 01270000
ALTER TABLE A914227B.TNZ243A1 01280000
ALTER PARTITION 31 01290000
ENDING AT (X'007BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01300000
COMMIT; 01310000
ALTER TABLE A914227B.TNZ243A1 01320000
ALTER PARTITION 32 01330000
ENDING AT (X'007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01340000
COMMIT; 01350000
ALTER TABLE A914227B.TNZ243A1 01360000
ALTER PARTITION 33 01370000
ENDING AT (X'0083FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01380000
COMMIT; 01390000
ALTER TABLE A914227B.TNZ243A1 01400000
ALTER PARTITION 34 01410000
ENDING AT (X'0087FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01420000
COMMIT; 01430000
ALTER TABLE A914227B.TNZ243A1 01440000
ALTER PARTITION 35 01450000
ENDING AT (X'008BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01460000
COMMIT; 01470000
ALTER TABLE A914227B.TNZ243A1 01480000
ALTER PARTITION 36 01490000
ENDING AT (X'008FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01500000
COMMIT; 01510000
ALTER TABLE A914227B.TNZ243A1 01520000
ALTER PARTITION 37 01530000
ENDING AT (X'0093FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01540000
COMMIT; 01550000
ALTER TABLE A914227B.TNZ243A1 01560000
ALTER PARTITION 38 01570000
ENDING AT (X'0097FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01580000
COMMIT; 01590000
ALTER TABLE A914227B.TNZ243A1 01600000
ALTER PARTITION 39 01610000
ENDING AT (X'009BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01620000
COMMIT; 01630000
ALTER TABLE A914227B.TNZ243A1 01640000
ALTER PARTITION 40 01650000
ENDING AT (X'009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01660000
COMMIT; 01670000
ALTER TABLE A914227B.TNZ243A1 01680000
ALTER PARTITION 41 01690000
ENDING AT (X'00A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01700000
COMMIT; 01710000
ALTER TABLE A914227B.TNZ243A1 01720000
ALTER PARTITION 42 01730000
ENDING AT (X'00A7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01740000
COMMIT; 01750000
ALTER TABLE A914227B.TNZ243A1 01760000
ALTER PARTITION 43 01770000
ENDING AT (X'00ABFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01780000
COMMIT; 01790000
ALTER TABLE A914227B.TNZ243A1 01800000
ALTER PARTITION 44 01810000
ENDING AT (X'00AFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01820000
COMMIT; 01830000
ALTER TABLE A914227B.TNZ243A1 01840000
ALTER PARTITION 45 01850000
ENDING AT (X'00B3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01860000
COMMIT; 01870000
ALTER TABLE A914227B.TNZ243A1 01880000
ALTER PARTITION 46 01890000
ENDING AT (X'00B7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01900000
COMMIT; 01910000
ALTER TABLE A914227B.TNZ243A1 01920000
ALTER PARTITION 47 01930000
ENDING AT (X'00BBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01940000
COMMIT; 01950000
ALTER TABLE A914227B.TNZ243A1 01960000
ALTER PARTITION 48 01970000
ENDING AT (X'00BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01980000
COMMIT; 01990000
ALTER TABLE A914227B.TNZ243A1 02000000
ALTER PARTITION 49 02010000
ENDING AT (X'00C3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02020000
COMMIT; 02030000
ALTER TABLE A914227B.TNZ243A1 02040000
ALTER PARTITION 50 02050000
ENDING AT (X'00C7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02060000
COMMIT; 02070000
ALTER TABLE A914227B.TNZ243A1 02080000
ALTER PARTITION 51 02090000
ENDING AT (X'00CBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02100000
COMMIT; 02110000
ALTER TABLE A914227B.TNZ243A1 02120000
ALTER PARTITION 52 02130000
ENDING AT (X'00CFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02140000
COMMIT; 02150000
ALTER TABLE A914227B.TNZ243A1 02160000
ALTER PARTITION 53 02170000
ENDING AT (X'00D3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02180000
COMMIT; 02190000
ALTER TABLE A914227B.TNZ243A1 02200000
ALTER PARTITION 54 02210000
ENDING AT (X'00D7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02220000
COMMIT; 02230000
ALTER TABLE A914227B.TNZ243A1 02240000
ALTER PARTITION 55 02250000
ENDING AT (X'00DBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02260000
COMMIT; 02270000
ALTER TABLE A914227B.TNZ243A1 02280000
ALTER PARTITION 56 02290000
ENDING AT (X'00DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02300000
COMMIT; 02310000
ALTER TABLE A914227B.TNZ243A1 02320000
ALTER PARTITION 57 02330000
ENDING AT (X'00E3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02340000
COMMIT; 02350000
ALTER TABLE A914227B.TNZ243A1 02360000
ALTER PARTITION 58 02370000
ENDING AT (X'00E7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02380000
COMMIT; 02390000
ALTER TABLE A914227B.TNZ243A1 02400000
ALTER PARTITION 59 02410000
ENDING AT (X'00EBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02420000
COMMIT; 02430000
ALTER TABLE A914227B.TNZ243A1 02440000
ALTER PARTITION 60 02450000
ENDING AT (X'00EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02460000
COMMIT; 02470000
02480000
--ALTER TABLE A914227B.TNZ243A1 02490000
-- ADD PARTITION ENDING AT 02500000
-- (X'00F3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02510000
--COMMIT; 02520000
--ALTER TABLE A914227B.TNZ243A1 02530000
-- ADD PARTITION ENDING AT 02540000
-- (X'00F7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02550000
--COMMIT; 02560000
--ALTER TABLE A914227B.TNZ243A1 02570000
-- ADD PARTITION ENDING AT 02580000
-- (X'00FBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02590000
--COMMIT; 02600000
--ALTER TABLE A914227B.TNZ243A1 02610000
-- ADD PARTITION ENDING AT 02620000
-- (X'00FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02630000
--COMMIT; 02640000