Re: storage clause

Regarding the storage clause, you might get a number of replies saying to use locally managed tablespace, so let me start. By now you should be using locally managed tablespaces with uniform allocation or automatic allocation depending on circumstances. Here is a link to more info...
http://asktom.oracle.com/pls/ask/f?p=4950:8:14825801344769954::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:895028559085, and/or just search that site. This topic has been addressed there quite well.

And this link for good info on the table size itself... http://asktom.oracle.com/pls/ask/f?p=4950:8:14825801344769954::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:406873025890,

Happy reading! (If you've never been to asktom, you'll find a lot of great information there.)

>>> netmadcap_at_netzero.com 02/20/03 03:19PM >>>
Hi Gurus ...

can somebody help in sizing the table/index using the storage clause ? what r the key values to check and how to calculate the table size & the related storage parameters ? how does it change from an OLTP appln to a Datawarehouse ?

lets say for the table "emp" :
Name Null? Type
------------ -------- ------------

EMPNO        NOT NULL NUMBER(4)
ENAME                 VARCHAR2(10)
JOB                   VARCHAR2(9)
MGR                   NUMBER(4)
HIREDATE              DATE
SAL                   NUMBER(7,2)
COMM                  NUMBER(7,2)
DEPTNO                NUMBER(2)

TIA !

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: <netmadcap_at_netzero.com 
  INET: netmadcap_at_netzero.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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  INET: DLANDRUM_at_zalecorp.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).