SET CURRENT SQLID = 'S100447'; 00010000
COMMIT; 00020000
00030000
SET CURRENT SQLID = 'S100447'; 00040000
COMMIT; 00050000
00060000
-- ALTER PARTITION 00070000
ALTER TABLE A540769.TNZ242A1 00080003
ALTER PARTITION 1 00090000
ENDING AT (X'0003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00100000
ALTER TABLE A540769.TNZ242A1 00110003
ALTER PARTITION 2 00120000
ENDING AT (X'0007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00130000
ALTER TABLE A540769.TNZ242A1 00140003
ALTER PARTITION 3 00150000
ENDING AT (X'000BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00160000
ALTER TABLE A540769.TNZ242A1 00170003
ALTER PARTITION 4 00180000
ENDING AT (X'000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00190000
ALTER TABLE A540769.TNZ242A1 00200003
ALTER PARTITION 5 00210000
ENDING AT (X'0013FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00220000
ALTER TABLE A540769.TNZ242A1 00230003
ALTER PARTITION 6 00240000
ENDING AT (X'0017FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00250000
ALTER TABLE A540769.TNZ242A1 00260003
ALTER PARTITION 7 00270000
ENDING AT (X'001BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00280000
COMMIT; 00290000
ALTER TABLE A540769.TNZ242A1 00300003
ALTER PARTITION 8 00310000
ENDING AT (X'001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00320000
COMMIT; 00330000
ALTER TABLE A540769.TNZ242A1 00340003
ALTER PARTITION 9 00350000
ENDING AT (X'0023FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00360000
COMMIT; 00370000
ALTER TABLE A540769.TNZ242A1 00380003
ALTER PARTITION 10 00390000
ENDING AT (X'0027FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00400000
COMMIT; 00410000
ALTER TABLE A540769.TNZ242A1 00420003
ALTER PARTITION 11 00430000
ENDING AT (X'002BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00440000
COMMIT; 00450000
ALTER TABLE A540769.TNZ242A1 00460003
ALTER PARTITION 12 00470000
ENDING AT (X'002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00480000
COMMIT; 00490000
ALTER TABLE A540769.TNZ242A1 00500003
ALTER PARTITION 13 00510000
ENDING AT (X'0033FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00520000
COMMIT; 00530000
ALTER TABLE A540769.TNZ242A1 00540003
ALTER PARTITION 14 00550000
ENDING AT (X'0037FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00560000
COMMIT; 00570000
ALTER TABLE A540769.TNZ242A1 00580003
ALTER PARTITION 15 00590000
ENDING AT (X'003BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00600000
COMMIT; 00610000
ALTER TABLE A540769.TNZ242A1 00620003
ALTER PARTITION 16 00630000
ENDING AT (X'003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00640000
COMMIT; 00650000
ALTER TABLE A540769.TNZ242A1 00660003
ALTER PARTITION 17 00670000
ENDING AT (X'0043FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00680000
COMMIT; 00690000
ALTER TABLE A540769.TNZ242A1 00700003
ALTER PARTITION 18 00710000
ENDING AT (X'0047FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00720000
COMMIT; 00730000
ALTER TABLE A540769.TNZ242A1 00740003
ALTER PARTITION 19 00750000
ENDING AT (X'004BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00760000
COMMIT; 00770000
ALTER TABLE A540769.TNZ242A1 00780003
ALTER PARTITION 20 00790000
ENDING AT (X'004FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00800000
COMMIT; 00810000
ALTER TABLE A540769.TNZ242A1 00820003
ALTER PARTITION 21 00830000
ENDING AT (X'0053FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00840000
COMMIT; 00850000
ALTER TABLE A540769.TNZ242A1 00860003
ALTER PARTITION 22 00870000
ENDING AT (X'0057FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00880000
COMMIT; 00890000
ALTER TABLE A540769.TNZ242A1 00900003
ALTER PARTITION 23 00910000
ENDING AT (X'005BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00920000
COMMIT; 00930000
ALTER TABLE A540769.TNZ242A1 00940003
ALTER PARTITION 24 00950000
ENDING AT (X'005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 00960000
COMMIT; 00970000
ALTER TABLE A540769.TNZ242A1 00980003
ALTER PARTITION 25 00990000
ENDING AT (X'0063FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01000000
COMMIT; 01010000
ALTER TABLE A540769.TNZ242A1 01020003
ALTER PARTITION 26 01030000
ENDING AT (X'0067FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01040000
COMMIT; 01050000
ALTER TABLE A540769.TNZ242A1 01060003
ALTER PARTITION 27 01070000
ENDING AT (X'006BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01080000
COMMIT; 01090000
ALTER TABLE A540769.TNZ242A1 01100003
ALTER PARTITION 28 01110000
ENDING AT (X'006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01120000
COMMIT; 01130000
ALTER TABLE A540769.TNZ242A1 01140003
ALTER PARTITION 29 01150000
ENDING AT (X'0073FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01160000
COMMIT; 01170000
ALTER TABLE A540769.TNZ242A1 01180003
ALTER PARTITION 30 01190000
ENDING AT (X'0077FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01200000
COMMIT; 01210000
ALTER TABLE A540769.TNZ242A1 01220003
ALTER PARTITION 31 01230000
ENDING AT (X'007BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01240000
COMMIT; 01250000
ALTER TABLE A540769.TNZ242A1 01260003
ALTER PARTITION 32 01270000
ENDING AT (X'007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01280000
COMMIT; 01290000
ALTER TABLE A540769.TNZ242A1 01300003
ALTER PARTITION 33 01310000
ENDING AT (X'0083FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01320000
COMMIT; 01330000
ALTER TABLE A540769.TNZ242A1 01340003
ALTER PARTITION 34 01350000
ENDING AT (X'0087FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01360000
COMMIT; 01370000
ALTER TABLE A540769.TNZ242A1 01380003
ALTER PARTITION 35 01390000
ENDING AT (X'008BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01400000
COMMIT; 01410000
ALTER TABLE A540769.TNZ242A1 01420003
ALTER PARTITION 36 01430000
ENDING AT (X'008FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01440000
COMMIT; 01450000
ALTER TABLE A540769.TNZ242A1 01460003
ALTER PARTITION 37 01470000
ENDING AT (X'0093FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01480000
COMMIT; 01490000
ALTER TABLE A540769.TNZ242A1 01500003
ALTER PARTITION 38 01510000
ENDING AT (X'0097FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01520000
COMMIT; 01530000
ALTER TABLE A540769.TNZ242A1 01540003
ALTER PARTITION 39 01550000
ENDING AT (X'009BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01560000
COMMIT; 01570000
ALTER TABLE A540769.TNZ242A1 01580003
ALTER PARTITION 40 01590000
ENDING AT (X'009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01600000
COMMIT; 01610000
ALTER TABLE A540769.TNZ242A1 01620003
ALTER PARTITION 41 01630000
ENDING AT (X'00A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01640000
COMMIT; 01650000
ALTER TABLE A540769.TNZ242A1 01660003
ALTER PARTITION 42 01670000
ENDING AT (X'00A7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01680000
COMMIT; 01690000
ALTER TABLE A540769.TNZ242A1 01700003
ALTER PARTITION 43 01710000
ENDING AT (X'00ABFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01720000
COMMIT; 01730000
ALTER TABLE A540769.TNZ242A1 01740003
ALTER PARTITION 44 01750000
ENDING AT (X'00AFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01760000
COMMIT; 01770000
ALTER TABLE A540769.TNZ242A1 01780003
ALTER PARTITION 45 01790000
ENDING AT (X'00B3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01800000
COMMIT; 01810000
ALTER TABLE A540769.TNZ242A1 01820003
ALTER PARTITION 46 01830000
ENDING AT (X'00B7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01840000
COMMIT; 01850000
ALTER TABLE A540769.TNZ242A1 01860003
ALTER PARTITION 47 01870000
ENDING AT (X'00BBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01880000
COMMIT; 01890000
ALTER TABLE A540769.TNZ242A1 01900003
ALTER PARTITION 48 01910000
ENDING AT (X'00BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01920000
COMMIT; 01930000
ALTER TABLE A540769.TNZ242A1 01940003
ALTER PARTITION 49 01950000
ENDING AT (X'00C3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 01960000
COMMIT; 01970000
ALTER TABLE A540769.TNZ242A1 01980003
ALTER PARTITION 50 01990000
ENDING AT (X'00C7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02000000
COMMIT; 02010000
ALTER TABLE A540769.TNZ242A1 02020003
ALTER PARTITION 51 02030000
ENDING AT (X'00CBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02040000
COMMIT; 02050000
ALTER TABLE A540769.TNZ242A1 02060003
ALTER PARTITION 52 02070000
ENDING AT (X'00CFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02080000
COMMIT; 02090000
ALTER TABLE A540769.TNZ242A1 02100003
ALTER PARTITION 53 02110000
ENDING AT (X'00D3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02120000
COMMIT; 02130000
ALTER TABLE A540769.TNZ242A1 02140003
ALTER PARTITION 54 02150000
ENDING AT (X'00D7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02160000
COMMIT; 02170000
ALTER TABLE A540769.TNZ242A1 02180003
ALTER PARTITION 55 02190000
ENDING AT (X'00DBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02200000
COMMIT; 02210000
ALTER TABLE A540769.TNZ242A1 02220003
ALTER PARTITION 56 02230000
ENDING AT (X'00DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02240000
COMMIT; 02250000
ALTER TABLE A540769.TNZ242A1 02260003
ALTER PARTITION 57 02270000
ENDING AT (X'00E3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02280000
COMMIT; 02290000
ALTER TABLE A540769.TNZ242A1 02300003
ALTER PARTITION 58 02310000
ENDING AT (X'00E7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02320000
COMMIT; 02330000
ALTER TABLE A540769.TNZ242A1 02340003
ALTER PARTITION 59 02350000
ENDING AT (X'00EBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02360000
COMMIT; 02370000
ALTER TABLE A540769.TNZ242A1 02380003
ALTER PARTITION 60 02390000
ENDING AT (X'00EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02400000
COMMIT; 02410000
02420000
ALTER TABLE A540769.TNZ242A1 02430003
ADD PARTITION ENDING AT 02440002
(X'00F3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02450002
COMMIT; 02460002
ALTER TABLE A540769.TNZ242A1 02470003
ADD PARTITION ENDING AT 02480002
(X'00F7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02490002
COMMIT; 02500002
ALTER TABLE A540769.TNZ242A1 02510003
ADD PARTITION ENDING AT 02520002
(X'00FBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02530002
COMMIT; 02540002
ALTER TABLE A540769.TNZ242A1 02550003
ADD PARTITION ENDING AT 02560002
(X'00FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'); 02570002
COMMIT; 02580002