Re: 2GB file size limit in Solaris?

From: MotoX <rat_at_tat.a-tat.com>
Date: Tue, 14 Jul 1998 07:53:36 +0100
Message-ID: <900399135.15509.0.nnrp-05.c2de712e@news.demon.co.uk>

It might also be worth checking if there are updates/patches for both Oracle and Solaris which allow you to use filesystems greater than 2G - there are for other UNIX platforms. Phone Oracle with the version numbers of both the OS and db you intend to use and get the latest status.

NB. Although you may be able to use datafiles larger than 2G, you might find that the Oracle tools (imp, exp, sqlloader) may still have the 2G restriction. Check the Oracle install docs and readme carefully.

MotoX.

Bob Withers wrote in message ...
>[This followup was posted to comp.databases.oracle.server and a copy was
>sent to the cited author.]
>
>In article <35AA7A33.6B3989F3_at_ot.com>, tim_at_ot.com says...
>> A company for whom I'm developing some applications on
>> 7.3/NT just purchased a Sun Sparc which will eventually
>> replace the NT box as the Oracle server. The vendor
>> installing the Sun and setting up Oracle has claimed that
>> there's a 2GB file size limit under Solaris? Is that so?
>>
>
>Hi Tim,
>
>Yes there is but your database can be made up of as many files as you
>like. I worked on a Solaris based Oracle data base that was in excess of
>2 terabytes.
>
>Bob
>
>--
>
>Bob Withers Do or do not, there is no try.
>bwit_at_pobox.com Yoda
Received on Tue Jul 14 1998 - 01:53:36 CDT