Oracle 大数据量复制 分区解决方式

drop table WZW_SALES;
drop table WZW_SALES_EXCHANGE;


create table WZW_SALES
(
  ACCT_NO      NUMBER(5),
  PERSON       VARCHAR2(30),
  SALES_AMOUNT NUMBER(8),
  WEEK_NO      NUMBER(2)
)
partition by range (WEEK_NO)
(
  partition PART9 values less than (9)
    tablespace TBS_USER_CAM
    pctfree 10
    pctused 40
    initrans 1
    maxtrans 255
  ,
  partition PART11 values less than (11)
    tablespace TBS_USER_CAM
    pctfree 10
    pctused 40
    initrans 1
    maxtrans 255
);


select * from wzw_sales partition (part9);


insert into wzw_sales values (1001,'person1',1245,8);
insert into wzw_sales values (1002,'person2',2845,7);
insert into wzw_sales values (2001,'person3',3645,9);