Re: Resizing Datafiles vs Adding Datafiles

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