Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partitioning

Re: Partitioning

From: Arup Nanda <orarup_at_hotmail.com>
Date: Thu, 27 Feb 2003 19:13:35 -0800
Message-ID: <F001.0055C7A6.20030227191335@fatcity.com>


RE: PartitioningIt's true for 9.2, too. It doesn't make sense to have different storage parameters for hash partitions.

  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: Arup Nanda
  INET: orarup_at_hotmail.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).
Received on Thu Feb 27 2003 - 21:13:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US