Re: File greater than 2 GB
From: Sergio Luiz Novaes (algol_at_LCC.UFMG.BR)
Date: 04/25/03
- Previous message: Aaron Morris: "Re: bulk mailer"
- Maybe in reply to: Faisal Qasim: "File greater than 2 GB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 25 Apr 2003 15:02:01 -0300 To: aix-l@Princeton.EDU
Sorry, but AIX 4.3.3 doesn't support such change (in mounted our umounted
filesystem), at least we had tried and no success (error: Field cannot be
changed). You must recreate your filesystems with large file support, or I
miss something ...
Sergio Luiz Novaes
LCC/UFMG - CENAPAD-MG/CO
Tel: +55 31 3499 5391/4936
Fax: +55 31 3499 5390
Scott Croft
<secroft@MICRON.C To: aix-l@Princeton.EDU
OM> cc:
Sent by: IBM AIX Subject: Re: File greater than 2 GB
Discussion List
<aix-l@Princeton.
EDU>
25/04/2003 14:38
Please respond to
secroft
No reboot is necessary, just a re-mount.
Which can be done on the fly if the filesystem is not being used.
Scott
On Fri, 2003-04-25 at 12:17, Baruch Shpirer wrote:
> 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
>
- Previous message: Aaron Morris: "Re: bulk mailer"
- Maybe in reply to: Faisal Qasim: "File greater than 2 GB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
