Thank you very much Conrad...
-----Original Message----- Sent: Wednesday, February 26, 2003 5:31 PM To: Conrad Meertins; Multiple recipients of list ORACLE-L 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Conrad Meertins INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).