Link to home
Start Free TrialLog in
Avatar of srikumar_p
srikumar_p

asked on

How can I create range sub partition?

Hi,

I am using Oracle 8.1.7. Is it possible to use range partitions inside another range partition. In other words, can I create range sub partitions inside another range partition? If yes, what is the syntax?

Thanks
Srikumar
ASKER CERTIFIED SOLUTION
Avatar of noriegaa
noriegaa
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kong
Kong
No you cannot have range-range partitioned tables.
Only partitions available are range, hash, and composite (range-hash).

It seems pretty pointless having range-range partitions since you can partition by range on more than one field:

CREATE TABLE emp
(empno NUMBER(9)
,ename VARCHAR2(20)
,sal   NUMBER(9)
,deptno NUMBER(9))
PARTITION BY RANGE (empno, deptno)
(PARTITION p1 VALUES LESS THAN (2000, 5000)
 TABLESPACE ts1
,PARTITION p2 VALUES LESS THAN (3000, 10000)
 TABLESPACE ts2
,PARTITION p3 VALUES LESS THAN (MAXVALUE, MAXVALUE)
 TABLESPACE ts3
);