hello, We have been using bigfile tablespace for years and have not faced specific issues with them. I recommend reading Niall's post http://orawin.info/blog/2012/01/05/adding-datafiles/ cheers Eric On 10 January 2012 03:09, G <andrew.kerber@xxxxxxxxx> wrote: > 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