RE: EXP > 2GB
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 16:09:14 -0500
John,
Check out the FILESIZE param for export. You can limit the size of the
export file. This is from the Export Docs:
Export supports writing to multiple export files, and Import can read from
multiple export files. If you specify a value (byte limit) for the FILESIZE
parameter, Export will write only the number of bytes you specify to each
dump file.
BM_1005717When the amount of data Export must write exceeds the maximum
value you specified for FILESIZE, it will get the name of the next export
file from the FILE parameter (see
<file:///E:/Ora9iDoc/server.920/a96652/ch01.htm#1005702> FILE
<file:///E:/Ora9iDoc/server.920/a96652/ch01.htm#1005702> for more
information) or, if it has used all the names specified in the FILE
parameter, it will prompt you to provide a new export filename. If you do
not specify a value for FILESIZE (note that a value of 0 is equivalent to
not specifying FILESIZE), then Export will write to only one file,
regardless of the number of files specified in the FILE parameter.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: John P Weatherman [mailto:asahoshi@xxxxxxxxxxxxxx]
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:
