Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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