From oracle-l-bounce@freelists.org Tue Mar 16 15:14:48 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2GLEmO19121 for ; Tue, 16 Mar 2004 15:14:48 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2GLEmo19115 for ; Tue, 16 Mar 2004 15:14:48 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B20439026B; Tue, 16 Mar 2004 16:13:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 16 Mar 2004 16:12:25 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from agency6.state.ky.us (agency6.state.ky.us [162.114.80.16]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B06C390DAB for ; Tue, 16 Mar 2004 16:12:25 -0500 (EST) Received: by agency6.state.ky.us with Internet Mail Service (5.5.2657.72) id ; Tue, 16 Mar 2004 16:18:19 -0500 Message-ID: <063F65E6A14D0C47A5E9954B3C323544042F28A0@agency31.state.ky.us> From: Surendra.Tirumala@ky.gov To: oracle-l@freelists.org Subject: RE: EXP > 2GB Date: Tue, 16 Mar 2004 16:18:12 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40B9C.30146264" X-archive-position: 958 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Surendra.Tirumala@ky.gov Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40B9C.30146264 Content-Type: text/plain; charset="iso-8859-1" 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@eds.com] Sent: Tuesday, March 16, 2004 4:05 PM To: 'oracle-l@freelists.org' 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@freelists.org [mailto:oracle-l-bounce@freelists.org]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 ------_=_NextPart_001_01C40B9C.30146264 Content-Type: text/html; charset="iso-8859-1"
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@eds.com]
Sent: Tuesday, March 16, 2004 4:05 PM
To: 'oracle-l@freelists.org'
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@freelists.org [mailto:oracle-l-bounce@freelists.org]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
------_=_NextPart_001_01C40B9C.30146264-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------