Oracle.表分区:散列分区
Oracle.表分区:散列分区
允许用户对不具有逻辑范围的数据进行分区
通过在分区键上执行HASH函数决定存储的分区
将数据平均地分布到不同的分区
语法:
- PARTITION BY HASH (column_name)
- PARTITIONS number_of_partitions;
或:
- PARTITION BY HASH (column_name)
- ( PARTITION part1 [TABLESPACE tbs1],
- PARTITION part2 [TABLESPACE tbs2],
- ...
- PARTITION partN [TABLESPACE tbsN]);
例:
- CREATE TABLE Employee
- (
- Employee_ID varchar2 (5),
- Employee_Name varchar2(20),
- Department varchar2 (10)
- )
- PARTITION BY HASH (Department)
- (
- Partition D1,
- Partition D2,
- Partition D3
- );
更多Oracle相关信息见Oracle 专题页面 http://www.bkjia.com/topicnews.aspx?tid=12
评论暂时关闭