//建立分區(qū)
create?tablespace?tsp_jn?
datafile?'E:\oracle\oradata\testtable\tsp_jn.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_jni?
datafile?'E:\oracle\oradata\testtable\tsp_jni.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_ta?
datafile?'E:\oracle\oradata\testtable\tsp_ta.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_lw?
datafile?'E:\oracle\oradata\testtable\tsp_lw.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_ly?
datafile?'E:\oracle\oradata\testtable\tsp_ly.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_zz?
datafile?'E:\oracle\oradata\testtable\tsp_zz.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_hz?
datafile?'E:\oracle\oradata\testtable\tsp_hz.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_wh?
datafile?'E:\oracle\oradata\testtable\tsp_wh.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_rz?
datafile?'E:\oracle\oradata\testtable\tsp_rz.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_zb?
datafile?'E:\oracle\oradata\testtable\tsp_zb.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_bz?
datafile?'E:\oracle\oradata\testtable\tsp_bz.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_dy?
datafile?'E:\oracle\oradata\testtable\tsp_dy.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_lc?
datafile?'E:\oracle\oradata\testtable\tsp_lc.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_dz?
datafile?'E:\oracle\oradata\testtable\tsp_dz.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_sd?
datafile?'E:\oracle\oradata\testtable\tsp_sd.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_yt?
datafile?'E:\oracle\oradata\testtable\tsp_yt.dbf'?
size?50m?
autoextend?on?
next?5m;

create?tablespace?tsp_wf?
datafile?'E:\oracle\oradata\testtable\tsp_wf.dbf'?
size?50m?
autoextend?on?
next?5m;


//建分區(qū)索引
CREATE?INDEX?fit_main_code?ON?fit_main(BRAND_CODE,FIT_CODE,PART_CODE,STYLE_CODE)?
PARALLEL
LOCAL?
(?
PARTITION?part_fit_main_jn?TABLESPACE?tsp_jn,?
PARTITION?part_fit_main_jni?TABLESPACE?tsp_jni,?
PARTITION?part_fit_main_ta?TABLESPACE?tsp_ta,?
PARTITION?part_fit_main_dz?TABLESPACE?tsp_dz,
PARTITION?part_fit_main_lc?TABLESPACE?tsp_lc,
PARTITION?part_fit_main_hz?TABLESPACE?tsp_hz,?
PARTITION?part_fit_main_ly?TABLESPACE?tsp_ly,?
PARTITION?part_fit_main_rz?TABLESPACE?tsp_rz,?
PARTITION?part_fit_main_wh?TABLESPACE?tsp_wh,
PARTITION?part_fit_main_yt?TABLESPACE?tsp_yt,
PARTITION?part_fit_main_wf?TABLESPACE?tsp_wf,?
PARTITION?part_fit_main_zb?TABLESPACE?tsp_zb,?
PARTITION?part_fit_main_bz?TABLESPACE?tsp_bz,?
PARTITION?part_fit_main_dy?TABLESPACE?tsp_dy,??
PARTITION?part_fit_main_lw?TABLESPACE?tsp_lw,?
PARTITION?part_fit_main_zz?TABLESPACE?tsp_zz,?
PARTITION?part_fit_main_sd?TABLESPACE?tsp_sd
);?