calculating space for new table?

[confident]

Hi friends,
rightnow i am in tablespace sizing of new project, can anybody tell,by looking from below table structure, for 1 million records, how much its occupies the space in tablespace..

CREATE TABLE ASC_OT_TPL
(
SDC_INST_N NUMBER(10)
ENTIY_TY CHAR(5),
TBL_NM VARCHAR2(20),
ANA_TIMESTAMP DATE
)
and db_block_size=8k
how i do calculate the sizing... any formula,pls tell me....

[gandolf989]

It will be between 45 and 50 megs. Add up the size of the columns, then multiply by the number of rows, and round up. Date fields are 7 bytes.

[jmodic]

Not enough information for any kind of estimation. You don't say what range of numbers will be stored in in NUMBER(10) column, what will be be the avarage length of the VARCHAR2(20) strings, you don't say how much NULL values will be stored in any of those table columns, etc etc.
So each row could occupy somewhere between 1 byte and slightly less than 40 bytes of space. Plus the block header overhead, plus PCTFREE, etc, etc...

[Mr.Hanky]

Create it and let us know.

[TimHall]

Hi.

In 10g you have a new segment resource estimation feature:

http://www.oracle-base.com/articles/...rce_estimation

Saves you having to work on homebrew methods.

Cheers

Tim...