叶节点

/************************oper_data_tab*****************************/
1、将原表的建表语法导出
2、将原表的数据另存
3、drop原表
4、根据导出的建表语法新建原表为分区表
5、将备份的数据导入

select distinct s6 from oper_data_tab--s6

create table oper_data_tab_copy as
select * from oper_data_tab

drop table oper_data_tab

-- Create table
create table OPER_DATA_TAB
(
EVENT_NO   VARCHAR2(12) not null,
RUN_MODE   VARCHAR2(100) not null,
STEAM_PRESS VARCHAR2(100),
HOT_PRESS   VARCHAR2(100),
Y_BURTHEN   VARCHAR2(100),
N_BURTHEN   VARCHAR2(100),
STEAM_TEM   VARCHAR2(100),
HOT_TEM   VARCHAR2(100),
STEAM_FLUX VARCHAR2(100),
NQQ_VACUUM VARCHAR2(100),
S1       VARCHAR2(100),
S2       VARCHAR2(20),
S3       VARCHAR2(100),
S4       VARCHAR2(100),
S5       VARCHAR2(100),
S6       VARCHAR2(100),
S7       VARCHAR2(400),
S8       VARCHAR2(400),
S9       VARCHAR2(2000),
S10       VARCHAR2(2000),
N1       NUMBER,
N2       NUMBER,
N3       NUMBER,
N4       NUMBER,
N5       NUMBER,
D1       DATE,
D2       DATE,
D3       DATE,
D4       DATE,
ROWVERSION DATE not null
)
partition by range (s6)
(
partition p01 values less than ('02'),
partition p02 values less than ('03'),
partition p03 values less than ('04'),
partition p04 values less than ('05'),
partition p05 values less than ('06'),
partition p06 values less than ('07'),
partition p07 values less than ('08'),
partition p08 values less than ('09'),
partition p09 values less than ('10'),
partition p10 values less than ('11'),
partition p11 values less than ('12'),
partition p12 values less than (maxvalue)
)
tablespace IFSAPP_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
  initial 16K
  minextents 1
  maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table OPER_DATA_TAB
add constraint OPER_DATA_PK primary key (EVENT_NO, RUN_MODE)
using index
tablespace IFSAPP_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
  initial 16K
  minextents 1
  maxextents unlimited
);


insert into oper_data_tab
select event_no, run_mode, steam_press, hot_press, y_burthen, n_burthen, steam_tem, hot_tem, steam_flux, nqq_vacuum, s1, s2, s3, s4, s5,
to_char(rowversion,'mm'), s7, s8, s9, s10, n1, n2, n3, n4, n5, d1, d2, d3, d4, rowversion from oper_data_tab_copy


select * from oper_data_tab partition(p12);