From: Baruch Shpirer (Baruch@Shpirer.com)
Date: Fri Apr 25 2003 - 14:17:03 EDT
I have detailed document on large file support in most common unix
systems
For the AIX platform I have checked this and verified it works
Here is how to enable LFS : ( The ORACLE will basicly be able to use
large files when the system is LFS enabled )
AIX
Configure or verify that the file system supports large files using
smit:
-> System Sotrage Managment
-> File Systems
-> Add/Change/Show Delete File Systems
-> Journaled File Systems
-> Change/Show Characterisitcs of journaled File System
-> Large File Enabled -> TRUE
I don't remember if I had to reboot or not , iam quite sure I needed to
even though it seemed to apply it to any file system that was remounted
For any problems about this , you can email me directly
Good luck.
Baruch Shpirer
Windows/*nix System & Network Admin.
Mobile +972-67-777167
Email baruch@shpirer.com
MSN bshpirer@hotmail.com
-----Original Message-----
From: IBM AIX Discussion List [mailto:aix-l@Princeton.EDU] On Behalf Of
James Jackson
Sent: Wednesday, April 23, 2003 4:56 PM
To: aix-l@Princeton.EDU
Subject: Re: File greater than 2 GB
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