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