Resizing Datafiles vs Adding Datafiles

When increasing the size of a tablespace you can either add a datafile or resize the datafile.

What is the difference?

Is there an advantage to one or the other?

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 feedback on this would be great.

Thanks for you time

Lowell

lfafard_at_cableregina.com Received on Sun Jul 23 2000 - 00:00:00 CDT