Re: Many small ones or one big one.

  • From: stephen booth <>
  • To: juancarlosreyesp@xxxxxxxxx
  • Date: Sat, 29 Jan 2005 00:16:12 +0000

I had to fix a problem last week where, in a 64bit Solaris 9 box,
someone had created a tablespace with  with four 30Gb datafiles. 
Unfortunately the backup device attached to that server had a maximum
capacity of about 20Gb per tape and the backup software couldn't split
large files over multiple tapes (and you really wouldn't want to). 
Also the projected datavolumes for the first year on this system are
around 3GB.  I'm all for allowing room for future growth, but there's
room for future growth and then there's being a bit daft.

That tablespace now has three 2Gb datafiles.


It's better to ask a silly question than to make a silly assumption.

Other related posts: