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.) >>> [EMAIL PROTECTED] 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: <[EMAIL PROTECTED] 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: Darrell Landrum 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).
