脚本建分区表改下,不要建空表再导入数据,直接根据原表建成分区表
脚本参考:
脚本参考:
create table tmp_acct_item_551_201502 parallel 4 nologging
partition by range (part)(
partition part0 values less than (1) tablespace OFCS_TBS_ACCT,
partition part1 values less than (2) tablespace OFCS_TBS_ACCT,
partition part2 values less than (3) tablespace OFCS_TBS_ACCT,
partition part3 values less than (4) tablespace OFCS_TBS_ACCT,
partition part4 values less than (5) tablespace OFCS_TBS_ACCT,
partition part5 values less than (6) tablespace OFCS_TBS_ACCT,
partition part6 values less than (7) tablespace OFCS_TBS_ACCT,
partition part7 values less than (8) tablespace OFCS_TBS_ACCT,
partition part8 values less than (9) tablespace OFCS_TBS_ACCT,
partition part9 values less than (10) tablespace OFCS_TBS_ACCT
)
as
select * from (
select a.prd_inst_id,a.charge,a.fee_type,to_number(substr(a.prd_inst_id,-1)) part
from dat_acct_item_551_201502 a ) ;
根据表里某个字段进行转换,做分区条件,建成分区表
to_number(substr(a.prd_inst_id,-1)) part
这个是根据原字段 进行转换做 分区条件
这个是根据原字段 进行转换做 分区条件