HASH_T SYS_P31 USERS 33334 58
6. 附录：11.2.0.3 版本数据库 分区表 延迟分配segment 测试
_sys@FAKE>select version from v$instance ;
VERSION
----------------------------------
11.2.0.3.0
_sys@FAKE>show parameter defe
NAME TYPE VALUE
------------------------------------ ----------------------------------------------------
deferred_segment_creation boolean TRUE
_dexter@FAKE>create table hash_t (id number )
2 partition by hash(id)
3 (partition &part_name1 tablespace users,
4 partition &part_name2 tablespace example,
5 partition &part_name3,
6 partition &part_name4) ;
Enter value for part_name1: p_t1
old 3: (partition &part_name1 tablespace users,
new 3: (partition p_t1 tablespace users,
Enter value for part_name2: p_t2
old 4: partition &part_name2 tablespaceexample,
new 4: partition p_t2 tablespaceexample,
Enter value for part_name3: p_t3
old 5: partition &part_name3,
new 5: partition p_t3,
Enter value for part_name4: p_t4
old 6: partition &part_name4)
new 6: partition p_t4)
Tablecreated.
_dexter@FAKE>select TABLE_NAME, PARTITION_NAME, TABLESPACE_NAME , NUM_ROWS , BLOCKS , segment_created fromuser_tab_partitions where table_name='HASH_T'
TABLE_NAMEPARTITION_NAME TABLESPACE NUM_ROWS BLOCKS SEGMENT_
---------- ------------------------------ ---------- ---------- ------------------
HASH_T P_T1 USERS NO
HASH_T P_T2 EXAMPLE NO
HASH_T P_T3 USERS NO
HASH_T P_T4 USERS NO