Re: Large exports on NT

Keep in mind 8i has a feature where export files can be broken up based on a file size, such as 1G. It creates file1, file2, etc. Therfore, assuming you have the drive space, you can have a 16G "export" broken up among 1G files.

On Fri, 10 Nov 2000 07:11:29
 TCarlson wrote:
>
>
>Unfortunately, all our instances, including SAP, are on NT 4.0 sp6a. I
>recently upgraded a server to 8.1.6.1.2 using export/import with a 5gig
>export file without a problem. Our SAP exports are in the 17-24gig. We keep
>our datafiles under 2 gig, but that is just from habit. I have heard the NT
>has a problem with files over 4 gig, but I have not validated this.
>
>
>
>
>
>"Smith, Ron L." <rlsmith_at_kmg.com> on 11/10/2000 07:35:26 AM
>
>Please respond to ORACLE-L_at_fatcity.com
>
>To: Multiple recipients of list ORACLE-L
>cc: (bcc: Todd Carlson)
>
>
>
>
>
>I need to move a 4G database from one NT server to another. On Unix there
>is a 2G limit on file sizes. Is the same limit true on NT or can I just do
>a full export and import?
>
>Ron Smith
>Database Administration
>rlsmith_at_kmg.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: TCarlson_at_bunge.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com Received on Fri Nov 10 2000 - 09:38:47 CST