Thanx for reminding about MAXDATAFILES Sonja. we already have 400 (with a max of 512) in oracle 11i environment. Need to think about it. Regards, Prem. On Fri, 02 Jul 2004 Sonja ©ehovi?Ewrote : >We have AIX 5.2 and Oracle 9.2.0.4 and use datafiles which are bigger = >then 2G. >It started when we hit maxdatafile number (200), and since it's = >production 7x24 it's not easy to get permission to bounce the database.=20 >So far, we keep them on 2,5GB > >HTH, >Sonja ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------