create table with range and hash partition,designate storage parameter for subpartit

[xiongye]

ÈçºÎ´´½¨·¶Î§ºÍhashµÄ¸´ºÏ·ÖÇø£¬²¢Îªsubpartition Ö¸¶¨´æ´¢²ÎÊý£¿
create table with range and hash partition,designate storage parameter for subpartition?
create table sales (
customer_id number(6),
sale_date date,
amount number(10) )
PARTITION BY RANGE(sale_date)
SUBPARTITION BY HASH(customer_id)
SUBPARTITIONS 2
( PARTITION p1 VALUES LESS THAN (to_date('2002/01/01','yyyy/mm/dd'))
(SUBPARTITION cdr_02_1999_01 TABLESPACE tbs1),
SUBPARTITION cdr_02_1999_02 TABLESPACE tbs2 ),
PARTITION p2 VALUES LESS THAN (MAXVALUE)
(SUBPARTITION cdr_05_1999_01 TABLESPACE tbs3 ,
SUBPARTITION cdr_05_1999_02 TABLESPACE tbs4));

I can not designate storage parameter to subpattition! Thanks !!!

[anandkl]

I guess it takes the storage parameter set at the table partition level.

please check...i am just guessing.

regards
anandkl

[Tarry]

Originally posted by xiongye
ÈçºÎ´´½¨·¶Î§ºÍhashµÄ¸´ºÏ·ÖÇø£¬²¢Îªsubpartition Ö¸¶¨´æ´¢²ÎÊý£¿
create table with range and hash partition,designate storage parameter for subpartition?
create table sales (
customer_id number(6),
sale_date date,
amount number(10) )
PARTITION BY RANGE(sale_date)
SUBPARTITION BY HASH(customer_id)
SUBPARTITIONS 2
( PARTITION p1 VALUES LESS THAN (to_date('2002/01/01','yyyy/mm/dd'))
(SUBPARTITION cdr_02_1999_01 TABLESPACE tbs1),
SUBPARTITION cdr_02_1999_02 TABLESPACE tbs2 ),
PARTITION p2 VALUES LESS THAN (MAXVALUE)
(SUBPARTITION cdr_05_1999_01 TABLESPACE tbs3 ,
SUBPARTITION cdr_05_1999_02 TABLESPACE tbs4));

I can not designate storage parameter to subpattition! Thanks !!!

I AIN'T...

DO THIS............

create table sales ( 
customer_id number(6), 
sale_date date, 
amount number(10) ) 
PARTITION BY RANGE(sale_date) 
SUBPARTITION BY HASH(customer_id) 
SUBPARTITIONS 2 
( PARTITION p1 VALUES LESS THAN (to_date('2002/01/01','yyyy/mm/dd')) 
 STORAGE (INITIAL 128K NEXT 128K) 
(SUBPARTITION cdr_02_1999_01 TABLESPACE tbs1), 
SUBPARTITION cdr_02_1999_02 TABLESPACE tbs2 ), 
PARTITION p2 VALUES LESS THAN (MAXVALUE) 
 STORAGE (INITIAL 128K NEXT 128K) 
(SUBPARTITION cdr_05_1999_01 TABLESPACE tbs3 , 
SUBPARTITION cdr_05_1999_02 TABLESPACE tbs4));

Cheers!

Tarry

[Tarry]

BTW I SEE
1. A SYNTACTICAL ERROR
2. A MISSING PARTITION CLAUSE
IN THIS SQL.
CORRECT IT AND RERUN THE SCRIPT.

TARRY