<强> 强> <强> 强>
间隔
create table test_range (idnumber test_date日期)
分区的范围(test_date)
(分区p_20160612值小于(to_date(' 20160613 ', '名称'))),
SQL> selecttable_name partitioning_type, partition_count,区间user_part_tableswhere table_name=皌est_range”;
table_name分区partition_count间隔
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
test_range NUMTODSINTERVAL范围(1天)
<强> 强>
SQL>插入test_range值(to_date(, '名称'));
1行创建。SQL>
提交;
提交完成。SQL>
选择table_name partition_namefrom user_tab_partitions table_name=癟EST_RANGE”;
table_name PARTITION_NAME
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TEST_RANGE
<强> 强>
SQL>插入TEST_RANGE值(to_date(, '名称'));
1行创建。SQL>
提交;
提交完成。SQL>
选择table_name partition_namefrom user_tab_partitions table_name=癟EST_RANGE”;
table_name PARTITION_NAME
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TEST_RANGE P_20160612
TEST_RANGE SQL>
插入TEST_RANGE值(to_date(, '名称'));——
1行创建。SQL>
提交;
提交完成。SQL>
选择table_name partition_namefrom user_tab_partitions table_name=癟EST_RANGE”;
table_name PARTITION_NAME
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TEST_RANGE P_20160612 TEST_RANGE
TEST_RANGE SQL>
插入TEST_RANGE值(to_date(, '名称'));——
1行创建。SQL>
提交;
提交完成。SQL>
选择table_name partition_namefrom user_tab_partitions table_name=癟EST_RANGE”;
table_name PARTITION_NAME
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TEST_RANGE P_20160612 TEST_RANGE
TEST_RANGE TEST_RANGE
<强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强> <强> 强>
删除表模板TEST_RANGE清洗;
create table TEST_RANGE (idnumber test_date日期)
分区的范围(test_date)间隔(numtodsinterval(1天))
subpartition通过散列(id)
(subpartition,
subpartition b
subpartition c)
(partitionp_20160612值小于(to_date(' 20160613 ', '名称'))),
<强> 强>
SQL>插入test_rangevalues (1, sysdate + 2);
1行创建。SQL>
提交;
提交完成。SQL>
选择table_name subpartition_namefrom user_tab_subpartitions table_name=癟EST_RANGE”;
table_name SUBPARTITION_NAME
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TEST_RANGE TEST_RANGE
TEST_RANGE TEST_RANGE
TEST_RANGE TEST_RANGE
SQL alter table TEST_RANGE addpartition P_20160615值小于(to_date(' 20160616 ', '名称'));
alter table TEST_RANGE添加分区P_20160615values不到(to_date(' 20160616 ', '名称'))*
误差在1号线:
ora - 14760:
<强>间隔强> <强>模板强> <强> 强>
删除表TEST_RANGE清洗;
create table TEST_RANGE (idnumber test_date日期)
分区的范围(test_date)
subpartition通过散列(id)
subpartition模板(subpartition,
subpartition b
subpartition c)
(partitionp_20160612值小于(to_date(' 20160613 ', '名称'))),
SQL alter table TEST_RANGE addpartition P_20160615值小于(to_date(' 20160616 ', '名称'));
表改变。SQL>
SQL>选择table_name subpartition_namefrom user_tab_subpartitions table_name=癟EST_RANGE”;
table_name SUBPARTITION_NAME
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TEST_RANGE TEST_RANGE
TEST_RANGE TEST_RANGE
TEST_RANGE TEST_RANGE
<强> 强> <强> 强> <强> 强> <强> 强> <强> 强>