Oracle表分区:范围分区
Oracle表分区:范围分区
以表中的一个列或一组列的值的范围分区
语法:
- PARTITION BY RANGE (column_name)
- (
- PARTITION part1 VALUE LESS THAN(range1),
- PARTITION part2 VALUE LESS THAN(range2),
- ...
- [PARTITION partN VALUE LESS THAN(MAXVALUE)]
- );
范围分区示例1:
- CREATE TABLE SALES2 (
- PRODUCT_ID VARCHAR2(5),
- SALES_DATE DATE NOT NULL,
- SALES_COST NUMBER(10))
- PARTITION BY RANGE (SALES_DATE)
- (
- PARTITION P1 VALUES LESS THAN (DATE ‘2003-01-01’),
- PARTITION P2 VALUES LESS THAN (DATE ‘2004-01-01’),
- PARTITION P3 VALUES LESS THAN (MAXVALUE)
- );
范围分区示例2:
- CREATE TABLE Sales
- (
- Product_ID varchar2 (5),
- Sales_Cost number (10)
- )
- PARTITION BY RANGE (Sales_Cost)
- (
- PARTITION P1 VALUES LESS THAN (1000),
- PARTITION P2 VALUES LESS THAN (2000),
- PARTITION P3 VALUES LESS THAN (3000)
- );
更多Oracle相关信息见Oracle 专题页面 http://www.bkjia.com/topicnews.aspx?tid=12
评论暂时关闭