From: Baruch Shpirer (Baruch@Shpirer.com)
Date: Fri Apr 25 2003 - 16:28:11 EDT
Well... Now that you mention it , I think I did make another filesystem
and moved the oracle directories and remounted to same mount point
Iam not as sure as I was when I sent the first letter , it was 2-3 years
ago
You need to create a new filesystem after changing to LFS and only then
will the new fs have LFS features
Sorry for missleading In my first letter
-----Original Message-----
From: Taylor, David [mailto:DTaylor@WBMI.com]
Sent: Friday, April 25, 2003 7:39 PM
To: baruch@Shpirer.com
Subject: RE: File greater than 2 GB
I'd be really interested to know how you verified the ability to
dynamically change a file-system to LFE.
As far as I know it cannot be done. You must delete it and create it as
LFE.
David
-----Original Message-----
From: Baruch Shpirer [mailto:Baruch@Shpirer.com]
Sent: Friday, April 25, 2003 1:17 PM
To: aix-l@Princeton.EDU
Subject: Re: File greater than 2 GB
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 email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:46 EDT