Oracle-L: Re: Partitioning

From: <babu.nagarajan_at_Cummins.com>
Date: Wed, 26 Feb 2003 14:19:04 -0800
Message-ID: <F001.0055A999.20030226141904@fatcity.com>

what do you mean by storage size? if you mean the initial, next and so on - yes you can.

if you are talking about how big it should be - i dont think you can do it...

Babu

                                                                                                                                                     
                      Conrad Meertins                                                                                                                
                      <cmeertins_at_pinnacl        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                
                      e-data.com>               cc:                                                                                                  
                      Sent by:                  Subject:  Partitioning                                                                               
                      root_at_fatcity.com                                                                                                               
                                                                                                                                                     
                                                                                                                                                     
                      02/26/03 04:44 PM                                                                                                              
                      Please respond to                                                                                                              
                      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: 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).




_____________
This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information.  If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited.  If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: babu.nagarajan_at_Cummins.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 Wed Feb 26 2003 - 16:19:04 CST