8.0.5 (at least) on NT has a fatal bug causing file corruption if the
filesize is > 2G. I
like to stick to a max of 2G for ease of maintenance, backups, etc.
"Randi Wølner" <randiwolner_at_hotmail.com> wrote in message
news:GME96.352$P2.178993152_at_news.telia.no...
> Someone told me that I should rather have a number of "small" datafiles
than
> to have one big.
> I have planned to have one datafile for a tablespace of 8 G (I use Oracle
> 8.1.5 for Windows NT - but will move
> to Unix platform soon).
> Should I instead have 4 datafiles of 2 G each, or 8 files of 1 G??
>
> And what about tablespaces - I have planned to keep alle my application's
> data in one tablespace (the one of 8 G),
> would it be better to divide them into more tablespaces?
>
> Can anyone give me some recommendation on what is best (and why)?
>
> Thanks a lot,
> Randi Wølner
>
>
Received on Thu Jan 18 2001 - 21:26:13 CST
