Oracle相关文档,希望互相学习,共同进步
1.背景
由于业务需求变更,之前表中指定的分区不够用了,需要新增分区。
2. 现有表
2.1 表创建命令
之前年月分区:
create table OPEN_SUN_PUBLIC_INFO ( kid VARCHAR2(32) not null, title VARCHAR2(255), sub_title VARCHAR2(255), enum_name VARCHAR2(255), start_date VARCHAR2(255), end_date VARCHAR2(255), create_by VARCHAR2(32), create_time DATE, update_by VARCHAR2(32), update_time DATE, deleted VARCHAR2(1) default on null '1' not null, bank_code VARCHAR2(32) not null, public_type VARCHAR2(20) default on null 'AUTO' not null, public_version VARCHAR2(30) default on null 'V1' not null ) PARTITION BY LIST (start_date) ( PARTITION P_202401 VALUES ('2024-01'), PARTITION P_202402 VALUES ('2024-02'), PARTITION P_202403 VALUES ('2024-03'), PARTITION P_202404 VALUES ('2024-04'), PARTITION P_202405 VALUES ('2024-05'), PARTITION P_202406 VALUES ('2024-06'), PARTITION P_202407 VALUES ('2024-07'), PARTITION P_202408 VALUES ('2024-08'), PARTITION P_202409 VALUES ('2024-09'), PARTITION P_202410 VALUES ('2024-10'), PARTITION P_202411 VALUES ('2024-11'), PARTITION P_202412 VALUES ('2024-12'), PARTITION P_202501 VALUES ('2025-01'), PARTITION P_202502 VALUES ('2025-02'), PARTITION P_202503 VALUES ('2025-03'), PARTITION P_202504 VALUES ('2025-04'), PARTITION P_202505 VALUES ('2025-05'), PARTITION P_202506 VALUES ('2025-06'), PARTITION P_202507 VALUES ('2025-07'), PARTITION P_202508 VALUES ('2025-08'), PARTITION P_202509 VALUES ('2025-09'), PARTITION P_202510 VALUES ('2025-10'), PARTITION P_202511 VALUES ('2025-11'), PARTITION P_202512 VALUES ('2025-12'), PARTITION P_202601 VALUES ('2026-01'), PARTITION P_202602 VALUES ('2026-02'), PARTITION P_202603 VALUES ('2026-03'), PARTITION P_202604 VALUES ('2026-04'), PARTITION P_202605 VALUES ('2026-05'), PARTITION P_202606 VALUES (