From: James Jackson (James.Jackson@MAIL.STATE.AR.US)
Date: Wed Apr 23 2003 - 10:55:52 EDT
The 2gb limit for exports and sql*loader files in Oracle is caused by
the way Oracle has implemented its file opens. Please refer to the
following extract from an Oracle doc for more information. You'll need
to dig a little deeper regarding the methods to work-around the 2gb
limit.
Export and 2Gb
~~~~~~~~~~~~~~ 2Gb Export File Size ~~~~~~~~~~~~~~~~~~~~
At the time of writing 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 or larger to a file system
file. There are several options available to overcome 2Gb file limits
with export such as:
- It is generally possible to write an export > 2Gb to a raw
device. Obviously the raw device has to be large enough to fit the
entire export into it.
- By exporting to a named pipe (on Unix) one can compress, zip
or split up the output. - One can export to tape (on most
platforms)
- Oracle8i allows you to write an export to multiple export files
rather than to one large export file.
Regards,
James Jackson
-----Original Message-----
From: Faisal Qasim [mailto:faisalq@cyber.net.pk]
Sent: Wednesday, April 23, 2003 8:34 AM
To: aix-l@Princeton.EDU
Subject: Re: File greater than 2 GB
Oracle version 7.
But how to create bigger files in AIX?
Regards
-----Original Message-----
From: Wesley Joyce [mailto:wjoyce@uvi.edu]
Sent: Wednesday, April 23, 2003 6:19 PM
To: faisalq@cyber.net.pk; aix-l@Princeton.EDU
Subject: Re: File greater than 2 GB
Oracle? What version? The exp command does allow you to export to
multiple files if you need to.
At 06:02 AM 4/23/2003, Faisal Qasim wrote:
>Dear all,
>
>In our AIX 4.3.3 box we could not create file greater than 2 GB. How
>can I enable creation of files > 2 GB size?
>
>- Relevant filesystem is 'large file enabled'
>- Soft file size and Hard file size for relevant user is -1
>- Error we are getting is:
>"EXP-00002: error in writing to export file
>EXP-00002: error in writing to export file "
>- df -k output :
>"/dev/dayend 4194304 1493864 65% 496 1% /dayend
>"
>
>I will be grateful for your help.
>
>
>Regards
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.474 / Virus Database: 272 - Release Date: 4/18/2003
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:46 EDT