--我们以为Scada_data表建立分区为例,以下是为scada_data表加表分区【范围分区】的全过程
-- 创建临时表
create table scada_data_temp(
scadad_id VARCHAR2(20) not null primary key,
node_id VARCHAR2(20) not null,
dc_id VARCHAR2(6) not null,
eq_id VARCHAR2(20) not null,
eq_no VARCHAR2(20),
eq_name NVARCHAR2(70),
conn_point_node VARCHAR2(20),
conn_point_eq_id VARCHAR2(20),
conn_point_eq_no VARCHAR2(20),
station_node VARCHAR2(20),
st_id VARCHAR2(20),
slave_station_sn NUMBER(10),
pf_id VARCHAR2(20),
fc_id VARCHAR2(20),
collection_time DATE not null,
param_name NVARCHAR2(50) not null,
tp_id VARCHAR2(20) not null,
param_value VARCHAR2(50),
org_id VARCHAR2(20) not
-- 创建临时表
create table scada_data_temp(
scadad_id VARCHAR2(20) not null primary key,
node_id VARCHAR2(20) not null,
dc_id VARCHAR2(6) not null,
eq_id VARCHAR2(20) not null,
eq_no VARCHAR2(20),
eq_name NVARCHAR2(70),
conn_point_node VARCHAR2(20),
conn_point_eq_id VARCHAR2(20),
conn_point_eq_no VARCHAR2(20),
station_node VARCHAR2(20),
st_id VARCHAR2(20),
slave_station_sn NUMBER(10),
pf_id VARCHAR2(20),
fc_id VARCHAR2(20),
collection_time DATE not null,
param_name NVARCHAR2(50) not null,
tp_id VARCHAR2(20) not null,
param_value VARCHAR2(50),
org_id VARCHAR2(20) not