On 9i export file can large than 2GB without problem.
You can also use filesize to setup max size you want
for multiple export files.
- "Mercadante, Thomas F"
<thomas.mercadante_at_labor.state.ny.us> wrote:
> 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
>
>
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com
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:14:36 CST