RE: EXP > 2GB

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 16 Mar 2004 16:04:50 -0500

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: