David Parry wrote:
>
> When first creating a table what should you use to determine the size of
> the datafile, and does it matter how big you make it because you can
> manually alter it anyway?
>
> David Parry
> dparry_at_nu-pharm.com
Hi David,
The datafile relates to a tablespace that will hold one or more tables
and or indexes. Determine all the tables or indexes that will be
contained in the tablespace and create the tablespace with the datafile
size large enough to hold all the objects including growth for say 6
months or a year. Yes you can alter the datafile to add or reduce
storage if you need to but this is an added chore for you if you don't
set up sizes at the beginning.
Regards,
Dick
Received on Thu Sep 04 1997 - 00:00:00 CDT
