oracle自动创建分区表，自动间隔分区‌（分区频率一年一次）

1.分区表必须有个date类型的字段，根据date类型的字段进行分区；
2.分区sql

create table CCMMESPRD.JM_TEST_DATA
(
  object_rrn      NUMBER(19) not null,
  org_rrn         NUMBER(19),
  is_active       VARCHAR2(1),
  created         DATE,--日期格式
  created_by      VARCHAR2(32),
  updated         DATE,
  updated_by      VARCHAR2(32),
  lock_version    NUMBER(19),
  component_id    VARCHAR2(128),
  lot_id          VARCHAR2(32),
  barcode         VARCHAR2(32),
  part_name       VARCHAR2(32),
  line_id         VARCHAR2(32),
  component_alias VARCHAR2(32),
  step_name       VARCHAR2(32),
  mac             VARCHAR2(32),
  ip              VARCHAR2(32),
  equipment_id    VARCHAR2(32),
  test_user       VARCHAR2(32),
  test_date       DATE,
  test_result     VARCHAR2(32),
  test_data       CLOB,
  action_type     VARCHAR2(32),
  fix_code        VARCHAR2(50),
  fix_location    VARCHAR2(10),
  testt2          VARCHAR2(10),
  defect_code     VARCHAR2(512)
)
PARTITION BY RANGE (created)
INTERVAL (NUMTOYMINTERVAL(1, 'YEAR'))  -- 自动按年扩展分区
(PARTITION p_start VALUES LESS THAN (DATE '2026-01-01'));--起始时间是20260101

3.插入2027年数据时，系统自动创建分区 SYS_P2027的分区