Yes you can. Check the storage option of the partition clause.
Something like:
create table (sales_yr varchar2(4),........)
partition by range (sales_yr)
(partition p1 values less than ('1996')
tablespace blah_p1
storage (initial 100M next 100M pctincrease 0),
partition p2 values less than ('2000')
tablespace blah_p2
storage (initial 200M next 200M pctincrease 0),
.....
)
/
BTW.. does you company sell 'DBA-IN-A_BOX' ???
HTH,
- Kirti
-----Original Message-----
Sent: Wednesday, February 26, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
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: Deshpande, Kirti
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).
