Oracle-L: Re:Partitioning

From: <dgoulet_at_vicr.com>
Date: Wed, 26 Feb 2003 14:34:06 -0800
Message-ID: <F001.0055A9D4.20030226143406@fatcity.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

I looked at dba_tab_partitions and dba_segments views. Although the show me storage information, I am unable to create a table where I can specify the storage size for each partition.

Am I doing something wrong Or you cannot specify a storage size for partitions.

Please help..

Thanks

Conrad...

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Conrad Meertins
INET: cmeertins_at_pinnacle-data.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------