Re: file size limitations?

From: Yvan Galas <yvan.galas_at_fr.adp.com>
Date: Thu, 03 Feb 2000 15:31:31 GMT
Message-ID: <38999F5C.47D5930C@fr.adp.com>

Jim Day wrote:
>
> We run Oracle 8.0.5 on Solaris 2.6. The users01.dbf file is current 1.7 GB
> in size. Is there a size limitation for any single *.dbf Oracle file on
> Solaris 2.6 (I thought I read once there was a 2GB file size limitation)?
> If so, 1) can someone point me to documentation on this restriction, and 2)
> what are my options?
>
> Thanks for your help.
>
> Jim

I can't help you on SUN but on my AIX

Yes it's true the limit it's 2Gb on the standard filesystem. But you have an option that's enable more than 2Gb files (Large file system)

Your options are :

1 - Split yours DBF files, for a 4Gb split into 4 pieces of 1Gb for example (user_1.dbf, user_2.dbf....)
2 - Use RAW datafile... no limits... (Hard drive limit...) Received on Thu Feb 03 2000 - 09:31:31 CST