oracle中哈希,oracle hash partition哈希分区(一)

前几篇文章:http://space.itpub.net/index.php?uid/9240380/action/spacelist/php/1,主要测试

range partition的语法及相关维护;

分区表除了范围分区,还有列表分区,哈希分区,组合分区(是范围,列表,哈希各种组合)及子分区;

先来测试哈希分区

测试情景:

SQL> select * from v$version where rownum=1;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

---参考资料:

---1,hash partition创建语法1

SQL> create table t_hash_partition(a int,b int)

2  partition by hash(a)

3  (partition p1 tablespace users,

4   partition p2 tablespace tbs_hang

5  );

Table created.

---2,查询hash partition表的分区及所属表空间

SQL> select table_name,partition_name,tablespace_name from user_tab_partitions

here table_name='T_HASH_PARTITION';

TABLE_NAME

------------------------------------------------------------

PARTITION_NAME

------------------------------------------------------------

TABLESPACE_NAME

------------------------------------------------------------

T_HASH_PARTITION

P1

USERS

T_HASH_PARTITION

P2

TBS_HANG

TABLE_