Oracle Database Discussions

Hi, I need some advice on the preferred way to define the following table, and a quick refresher on size estimating for tables. Info and DDL on the table is below:

Approx. 1 Mil rows populated / day. (one rec for every PARTID and LOCATIONDETAILID and INVENTORYDTTM combination where INVENTORYDTTM = the current days date, the table is populated daily.

Effectivley, taking a snapshot of inventory QTY for every LOCATIONDETAILID with a PARTID every day.

Based on the width of the table, how do I best calculated the size in bytes for this many rows? Once I know that, and the number of and frequency of inserts, is there an obvious choice for a preferred storage paramter?

Many thanks in advance for you help,
Scott


CREATE TABLE INVENTORY (
INVENTORYTYPE CHAR (1),
INVENTORYDTTM DATE,
LOCATIONDETAILID NUMBER,
PARTID NUMBER,
QTY NUMBER,
POSTED CHAR (1),
POSTEDDTTM DATE)
TABLESPACE CATS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;


CREATE INDEX INVENTORY_1 ON
INVENTORY(INVENTORYDTTM)
TABLESPACE CATS PCTFREE 10 STORAGE(INITIAL 65536 )
;

CREATE INDEX INVENTORY_2 ON
INVENTORY(LOCATIONDETAILID)
TABLESPACE CATS PCTFREE 10 STORAGE(INITIAL 65536 )
;

CREATE INDEX INVENTORY_3 ON
INVENTORY(PARTID)
TABLESPACE CATS PCTFREE 10 STORAGE(INITIAL 65536 )
;