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: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
>
> 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" <cmeertins_at_pinnacle-data.com>
> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).