Thanks for your valuable input. We will use SQL loader within script so that transportable tablespace would not help much.

I agrre that PCTFREE should be zero. what is the ideal size of PCTUSED. It is static data.

I belive that table should be created with nologging option to improve performance also.

The partitioning concept on date column would be also useful.

Can you pl. make your comment on it?

Can you pl. give me more idea technically how to perform and achive it for your below suggestion?

Consider ordering the data prior to insert by common reporting predicates so as to improve the clustering factor on those columns' indexes and reduce physical i/o on retrieval.

Estimate the size by loading a representative sample and measuring it.