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                                                  
                                                              
                      <[EMAIL PROTECTED]        To:       Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>                                
                      e-data.com>               cc:                                    
                                                              
                      Sent by:                  Subject:  Partitioning                 
                                                              
                      [EMAIL PROTECTED]                                                
                                                               
                                                                                       
                                                              
                                                                                       
                                                              
                      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: [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).




_____________
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: [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).

Reply via email to