----- Original Message -----
Sent: Wednesday, February 26, 2003 6:39
PM
Subject: RE: Partitioning
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
