RE: Big files

  • From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • To: "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Jan 2012 20:51:13 +0000

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of G
Sent: Monday, January 09, 2012 6:09 PM
To: oracle-l@xxxxxxxxxxxxx
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--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: