//建立分区 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;
//建分区索引 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 );
|
|
|
| 日 | 一 | 二 | 三 | 四 | 五 | 六 |
---|
27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|
导航
统计
- 随笔: 46
- 文章: 14
- 评论: 27
- 引用: 0
常用链接
留言簿(1)
随笔档案
文章档案
收藏夹
搜索
积分与排名
最新评论
阅读排行榜
评论排行榜
|
|