I'll add that for HASH partitions or subpartitions you can only specify TABLESPACE, all other storage parameters are taken from table / partition defaults. At least in 8.1.7.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> YES, here's an example:
>
> create table ate_headers(module_id varchar2(13),
> session_number varchar2(16),
> test_group number(4),
> test_date date,
> first_record char(1) default 'F',
> last_record char(1) default 'F',
> tester_id number(4),
> slot number(6),
> test_kind number(4),
> work_order varchar2(15),
> session_duration number,
> program_id number(4),
> spec_name varchar2(20),
> spec_revision varchar2(2),
> vector_name varchar2(12),
> vector_revision varchar2(2),
> bin_number number(6),
> constraint test_header_fk
> foreign key (module_id)
> references module_master(module_id)
> on delete cascade)
> partition by range (test_group)
> ( partition h1q398 values less than (2) tablespace ate1
> storage(initial 150M
> next 150M maxextents 99),
> partition h2q398 values less than (3) tablespace ate2
> storage(initial 150M
> next 150M maxextents 99),
> partition h3q398 values less than (4) tablespace ate3
> storage(initial 150M
> next 150M maxextents 99),
> partition h4q398 values less than (5) tablespace ate4
> storage(initial 150M
> next 150M maxextents 99),
> /* partition h5q398 values less than (6) tablespace ate5
> storage(initial 150M
> next 150M maxextents 99), */
> partition h6q398 values less than (100) tablespace ate6
> storage(initial 150M
> next 150M maxextents 99));
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Conrad Meertins" <[EMAIL PROTECTED]>
> Date: 2/26/2003 1:44 PM
>
>
> If you have a table partitioned, can you specify the storage
> size of each
> partition in that tables