RE: EXP > 2GB

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 16 Mar 2004 16:09:14 -0500
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD59EB@exchsen0a1ma>

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_at_infionline.net] 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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 16 2004 - 15:05:43 CST