Re: Export >2GB files w/7.3.4.3.0 & Solaris 2.6

You dont say what Oracle versions you are dealing with, but there is an article on Oracle's Metalink called
'2Gb or Not 2Gb - File limits in Oracle' <Note:62427.1> dated 05-Nov-1998 that discusses exports over 2G. It states that

"....most versions of export use the default file open API when creating an export file. This means that on many platforms it is impossible to export a file of 2Gb file limits with export...."

So you may want to check out your version of export and see if this applies. We are on HP-UX not Solaris, but we are successfully exporting via named pipes to a zipped file to get around the 2G file limits at this time.

Bob Wickline wrote:

> OK. I convinced my customer to let me upgrade to Solaris 2.6 (took me
> 4 months!) so we can perform full database exports which have grown
> past the 2GB file size limit on Solaris 2.5.1. However, I STILL
> cannot export a file past 2GB.
>
> WHY?!?!
>
> I can issue the command "mkfile 3000M testfile" as oracle so I know
> that I have all the ulimit stuff fixed. However, when I try to either
> create a datafile larger than 2GB or export to a file >2GB it crashes.
>
> What's up?

--
Linda Montgomery
Database Analyst
James Madison University
montgolh_at_jmu.edu Received on Fri Feb 26 1999 - 08:46:48 CST