"zeb" <spam_at_nowhere.com> wrote in message news:<419f0b8e$0$5181$636a15ce_at_news.free.fr>...
> Hi,
>
> Can I use safely datafile larger than 2 GB ?
> I know it is a file system limitation not oracle limitation,
> now on recent filesystem there is no such limitation.
>
> Is this a "psychologic" limitation ?
> Is there any known bugs ?
> perfomance pb ?
> management ?
>
> Can I go safely with this ??
>
> oracle 8i, 9i
> AIX 4, 5
> HP-UX 11.0
On AIX, you must ensure the /etc/security/limits file has an unlimited
entry for the oracle user regarding file size. We got burned on this
when we had our files set to autoextend, and the sysadmin had set it
to 1GB. Once it was changed, we could make them whatever we wanted.
Received on Mon Nov 22 2004 - 08:09:51 CST
