subpartition by hash(name) --以name列作为分区键创建HASH子分区 subpartitions 2 store in(TBS_TEST_1,TBS_TEST_2) --HASH子分区共有两个,分别存储在两个不同的命名空间中 ( partition par1 values less than(5000), --范围分区,id小于5000 partition par2
) partition by list(列名) subpartition by hash(列名)( partition 主分区名1 values (值1,值2,值3,...) tablespace 表空间名1( subpartition 子分区名11, subpartition 子分区名12, ... ), partition 主分区名2 values (值1,值2,值3,...) tablespace 表空间名2( subpartition 子分区名21, subpartit...
SQL>createtabletest partitionbyrange(object_id) subpartitionbyhash(object_type) subpartitions4(partition p1valuesless than(10000), partition p2valuesless than(20000), partition p3valuesless than(30000), partition p4valuesless than(maxvalue))asselect*fromdba_objects;--收集统计信息sql>BEGINdbms_stats...
partition by range(transaction_date)subpartition by hash(transaction_id) subpartitions3store in (dinya_space07,dinya_space08,dinya_space09) ( partition part_07 values less than(to_date('2006-01-01','yyyy-mm-dd')), partition part_08 values less than(to_date('2010-01-01','yyyy-mm-dd'...
create tableuser(user_idvarchar2(20char),user_namevarchar2(50char),part_flagNUMBER(1))partition byrange(part_flag)subpartition byhash(user_id,user_name)(partition p1 values lessthan(50)(subpartition sp1,subpartition sp2),partition p2 values lessthan(100)(subpartition sp3,subpartition sp4)) ...
PARTITION BY range (grade) SUBPARTITION BY HASH (losal,hisal) ( PARTITION P1 VALUES less than(10) ( SUBPARTITION t1, SUBPARTITION t2 ), partition p2 VALUES less than (20) ( SUBPARTITION t3, SUBPARTITION t4 ) ); -- 插入数据: INSERT INTO salgrade VALUES(1,700,1200); ...
//范围+散列分区 create table graderecord ( sno varchar2(10), sname varchar2(10), dormitory varchar2(5), grade int ) partition by range(grade) subpartition by hash(sno,sname) ( partition p1 values less than(75) ( subpartition sp1,subpartition sp2 ), partition p2 values less than(maxvalue...
partition by range(transaction_date)subpartition by hash(transaction_id) subpartitions 3 store in (dinya_space01,dinya_space02,dinya_space03) ( partition part_01 values less than(to_date(‘2006-01-01’,’yyyy-mm-dd’)), partition part_02 values less than(to_date(‘2010-01-01’,’yyyy...
DROP SUBPARTITION technology_go_29; 1. 2. 复制 5、范围哈希组合分区 (1)建表语句 create table WORKER_202306 ( id VARCHAR2(100) not null, name VARCHAR2(200), technology VARCHAR2(100), save_date DATE ) partition by range (SAVE_DATE) SUBPARTITION BY HASH (id) ...
l全局索引(global index):即可以分区,也可以不分区。即可以建range分区,也可以建hash分区,即可建于分区表,又可创建于非分区表上,就是说,全局索引是完全独立的,因此它也需要我们更多的维护操作。 l本地索引(local index):其分区形式与表的分区完全相同,依赖列相同,存储属性也相同。对于本地索引,其索引分区的维护...