【Oracle专栏】分区表增加分区

发布于:2025-07-06 ⋅ 阅读:(19) ⋅ 点赞:(0)

 Oracle相关文档,希望互相学习,共同进步

风123456789~-CSDN博客


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 (

网站公告

今日签到

点亮在社区的每一天
去签到