Re: Resizing Datafiles vs Adding Datafiles

Actually we autoextend the datafile to our OS file size limit (maxsize 2GB) and attach a new datafile if any objects cannot extend (or are close). That way I never have to worry about the filesize greater than 2GB.

Nuno Souto wrote:

> On Mon, 24 Jul 2000 13:22:17 GMT, Troy Meyerink
> <meyerink_at_edcmail.cr.usgs.gov> wrote:
>
> >I would agree with your conclusion. Other OS limitations might come into play,
> >like I know certain UNIX's have a 2GB file limitation size. I might need to 2GB
> >datafiles for the same tablespace.
> >
> >>snip...
> >> As far as I can tell the only advantage to adding a datafile to a tablespace
> >> would be performance and spreading the tablespace of more disks, but for
> >> small databases resizing the datafiles would seem more beneficial, less
> >> datafiles easier to manage.
> >>
>
> Any of you guys ended up with a corrupt database after an expanding
> file went over the max size of the file system? I have. No more
> expanding files for me, thanx. I'd rather get an extend refused than
> have to recover a database...
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Mon Jul 24 2000 - 00:00:00 CDT