| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: EXP > 2GB
Do we really have to worry about this 2GB limit? I don't think so. I have my
dump file sizes well over 2GB with all my production databases.I did some
research couple of years back and left the export jobs untouched. And I
never faced any problems in using these dump files.
My env is Sun and the Note:62409.1 will give more details.
On AIX, I think, 2GB limit still applies.
Thanks,
Surendra
-----Original Message-----
From: Powell, Mark D [mailto:mark.powell_at_eds.com]
Sent: Tuesday, March 16, 2004 4:05 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: EXP > 2GB
John, if you pull the 9.2 Utilities manual and look at the export parameters you will see that FILESIZE limits the number of bytes written to any one export file and FILE allows you to specify a series of export files to be exported to up to FILESIZE.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of John P Weatherman
Sent: Tuesday, March 16, 2004 3:57 PM
To: oracle-l
Subject: EXP > 2GB
All,
I have an export (9.2.0.4 on Solaris 9) that has recently grown beyond the default exp 2GB filesize limit. For the time being, I have implemented exporting through a named pipe to generate the file "pre-compressed". However, I think I heard about there being a patch to relink exp to handle large file sizes at some point. I can't find anything on Google or Metalink right now. Am I miss-remembering something or does somebody know about this/know where the documentation is?
TIA,
John P Weatherman
Oracle Database Administrator
Advance America
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Tue Mar 16 2004 - 15:14:48 CST
-----------------------------------------------------------------
 |
 |