RE: EXP > 2GB
- From: Surendra.Tirumala@xxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 Mar 2004 16:18:12 -0500
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@xxxxxxx]
Sent: Tuesday, March 16, 2004 4:05 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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
Other related posts:
