Re: Resize or add Datafiles

Hi,
adding datafiles allows you "stripe" a tablespace across multiple disks, and to allocate extents for tables to a specific datafile. Resizing datafiles doesn't require you to take an immediate backup, or create a copy of the control file as the resize command is recorded in the redo ./ archive logs. Whereas when adding a datafile you should backup the datafile and take a copy of the controlfile (backup conrolfile to trace)

Also, in some versions of 7.3 there were some bugs when resizing datafiles when using multiple dbwr processes.

HTH Neil

Gordan Freeman wrote in message <382682db.253167385_at_158.152.254.65>...
>What are the pros and cons between adding datafiles to tablespaces or
>resizing existing ones to bigger sizes. The only advantages I see over
>adding datafiles is to allow you to place them on bigger disks and
>perhaps give you contiguous free space.
>
>Any more advatages.
>
>Matthew
Received on Mon Nov 08 1999 - 04:49:23 CST