Calulate the average row size(35+2+35+7) 7bytes for date. Multiply with no. of rows and see whats its growth per day and forcast it for howmany days/months/yeers you want to allocate space. Its just rough estmate... refer docs for clear details on calculations.

Allocate that much size for tablespace. say 200MB.

Create a datafile with 200MB+2 Oracle_blocks for over head.

I would advise you to read the tech paper on fragmentation SAFE which talks about space management and fragmentation. You can find in couple of my postings... search for it.

[Edited by sreddy on 01-23-2001 at 11:16 AM]