创建range-list(范围-列表)组合分区!
来源:互联网 发布:navicat找不到数据库 编辑:程序博客网 时间:2024/05/01 00:25
--创建range-list组合分区:
SQL> create table t_partition_rl (id number,name varchar2(50)) 2 partition by range(id) subpartition by list(name) 3 subpartition template ( 4 subpartition l1 values ('aa') tablespace tbspart01, 5 subpartition l2 values ('bb') tablespace tbspart02, 6 subpartition l3 values ('cc') tablespace tbspart03, 7 subpartition l4 values ('dd') tablespace tbspart04)( 8 partition t_r_p1 values less than (10) tablespace tbspart01, 9 partition t_r_p2 values less than (20) tablespace tbspart02, 10 partition t_r_p3 values less than (30) tablespace tbspart03, 11 partition t_r_pd values less than (maxvalue) tablespace tbspart04);表已创建。SQL> select TABLE_NAME,PARTITIONING_TYPE,PARTITION_COUNT from user_part_tables where TABLE_NAME = 'T_PARTITION_RL';TABLE_NAME PARTITI PARTITION_COUNT------------------------------ ------- ---------------T_PARTITION_RL RANGE 4SQL> select PARTITION_NAME,HIGH_VALUE,TABLESPACE_NAME from user_tab_partitions where TABLE_NAME = 'T_PARTITION_RL';PARTITION_NAME HIGH_VALUE TABLESPACE_NAME------------------------------ -------------------- ------------------------------T_R_P1 10 TBSPART01T_R_P2 20 TBSPART02T_R_P3 30 TBSPART03T_R_PD MAXVALUE TBSPART04SQL> select partition_name,subpartition_name,tablespace_name from user_tab_subpartitions where table_name='T_PARTITION_RL';PARTITION_NAME SUBPARTITION_NAME TABLESPACE_NAME------------------------------ ------------------------------ ------------------------------T_R_P1 T_R_P1_L4 TBSPART01T_R_P1 T_R_P1_L3 TBSPART01T_R_P1 T_R_P1_L2 TBSPART01T_R_P1 T_R_P1_L1 TBSPART01T_R_P2 T_R_P2_L4 TBSPART02T_R_P2 T_R_P2_L3 TBSPART02T_R_P2 T_R_P2_L2 TBSPART02T_R_P2 T_R_P2_L1 TBSPART02T_R_P3 T_R_P3_L4 TBSPART03T_R_P3 T_R_P3_L3 TBSPART03T_R_P3 T_R_P3_L2 TBSPART03PARTITION_NAME SUBPARTITION_NAME TABLESPACE_NAME------------------------------ ------------------------------ ------------------------------T_R_P3 T_R_P3_L1 TBSPART03T_R_PD T_R_PD_L4 TBSPART04T_R_PD T_R_PD_L3 TBSPART04T_R_PD T_R_PD_L2 TBSPART04T_R_PD T_R_PD_L1 TBSPART04已选择16行。
--对于复合分区的local索引:
SQL> create index idx_part_rl_id on t_partition_rl(id) local;索引已创建。SQL> select table_name,partitioning_type,partition_count,def_subpartition_count from user_part_indexes where index_name = 'IDX_PART_RL_ID';TABLE_NAME PARTITI PARTITION_COUNT DEF_SUBPARTITION_COUNT------------------------------ ------- --------------- ----------------------T_PARTITION_RL RANGE 4 4SQL> select partition_name,subpartition_count,high_value from user_ind_partitions where index_name = 'IDX_PART_RL_ID';PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE------------------------------ ------------------ --------------------T_R_P1 4 10T_R_P2 4 20T_R_P3 4 30T_R_PD 4 MAXVALUESQL> select partition_name,subpartition_name,high_value,tablespace_name from user_ind_subpartitions where index_name = 'IDX_PART_RL_ID';PARTITION_NAME SUBPARTITION_NAME HIGH_VALUE TABLESPACE_NAME------------------------------ ------------------------------ -------------------- ------------------------------T_R_P1 T_R_P1_L1 'aa' TBSPART01T_R_P1 T_R_P1_L2 'bb' TBSPART01T_R_P1 T_R_P1_L3 'cc' TBSPART01T_R_P1 T_R_P1_L4 'dd' TBSPART01T_R_P2 T_R_P2_L1 'aa' TBSPART02T_R_P2 T_R_P2_L2 'bb' TBSPART02T_R_P2 T_R_P2_L3 'cc' TBSPART02T_R_P2 T_R_P2_L4 'dd' TBSPART02T_R_P3 T_R_P3_L1 'aa' TBSPART03T_R_P3 T_R_P3_L2 'bb' TBSPART03T_R_P3 T_R_P3_L3 'cc' TBSPART03PARTITION_NAME SUBPARTITION_NAME HIGH_VALUE TABLESPACE_NAME------------------------------ ------------------------------ -------------------- ------------------------------T_R_P3 T_R_P3_L4 'dd' TBSPART03T_R_PD T_R_PD_L1 'aa' TBSPART04T_R_PD T_R_PD_L2 'bb' TBSPART04T_R_PD T_R_PD_L3 'cc' TBSPART04T_R_PD T_R_PD_L4 'dd' TBSPART04已选择16行。
- 创建range-list(范围-列表)组合分区!
- 创建range-hash(范围-哈希)组合分区!
- 创建range(范围)分区!
- oracle 分区,range-list,范围-列表复合分区
- 分区表及分区索引(6)--创建range-list组合分区
- 创建list(列表)分区!
- 深入学习分区表及分区索引(6)--创建range-list组合分区
- 分区表及分区索引(5)--创建range-hash组合分区
- 复合分区 (范围-散列分区,范围-列表分区)
- IndexError: list index out of range列表索引超出范围
- MySQL表分区(1)范围分区-range
- range,hash,list分区
- ORACLE 范围分区 partition-range分区
- 组合分区与范围分区效率对比测试(1)
- 组合分区与范围分区效率对比测试(2)
- 创建range分区
- 创建range分区
- PARTITION RANGE分区创建
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- Android 打包签名 从生成keystore到完成签名
- Private strand flush not complete 说明
- Xml
- Oracle Redo 并行机制
- 创建range-list(范围-列表)组合分区!
- Oracle Sequence Cache 参数说明
- sql语句
- repeater隔行变色问题(非js)
- DB 迁移到Data Guard 实施方案
- Oracle Exadata 简介
- Oracle ORION IO 测试工具
- XML(DOM)(No.20)
- Oracle 索引可以比表大