RE: Big files
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 10 Jan 2012 20:51:13 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA82781F1_at_M1EXCHMB13.mmi.local>
If you ever fill up your tablespace and the datafile is on a LUN (as opposed to NFS) which cannot be easily extended, you are in a bit of a spot. This happened to me and I had to create a smallfile TS across a few mount points and move objects out of the bigfile TS.
Date: Tue, 10 Jan 2012 20:51:13 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA82781F1_at_M1EXCHMB13.mmi.local>
If you ever fill up your tablespace and the datafile is on a LUN (as opposed to NFS) which cannot be easily extended, you are in a bit of a spot. This happened to me and I had to create a smallfile TS across a few mount points and move objects out of the bigfile TS.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of G
Sent: Monday, January 09, 2012 6:09 PM
To: oracle-l_at_freelists.org
Subject: Big files
Does anyone have opinions/experience/preferences on bigfile tablespaces? I had someone ask recently, but I have always used smallfile tablespaces.
Sent from my iPhone--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 10 2012 - 14:51:13 CST