We have used 16GB at times ... but we use sushi files (raw not cooked) Raj --- Prem Khanna J <premj@xxxxxxxxxxxxxx> wrote: > Hi All, > The env. is oracle 9.2.0.4 & AIX 5.2L (64 bit) > > What is the safe limit for maximum datafile size ? > I see lot of articles about 2GB limitation. > > Any advise would be greatly helpful. > > Thanks. > Prem. ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- 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 -----------------------------------------------------------------