In 8i I just use the parameter filesize and file. When export
hits the limit of filesize, it switches to the next file in the comma
delimited list I've specified with the file parameter.
----- Original Message -----
From: <TCarlson_at_bunge.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, November 10, 2000 11:27 AM
Subject: Re: FW: [Fwd: Re: Large exports on NT]
>
>
> NT's NTFS has a theoretical limit in the terabyte range. What parameter is
> used to tell Oracle to use multiple files for an export?
>
>
>
>
>
> Paul Drake <drake_at_psscorp.com> on 11/10/2000 10:01:15 AM
>
> To: ORACLE-L
> cc: Todd Carlson
>
>
>
>
>
> Hi.
>
> NT Server 4.0 has a hard limit (NTFS) of 16 GB.
> Funny how we found that one out ... it turned out to be the brakes for a
> temporary tablespace's datafile on a runnaway process.
>
> What version of Oracle - I know with 8.1.6 you can tell exp to use multiple
> files of a certain slice size ...
>
> Getting off-track here, but I can't think of any reason that anyone would
> ever want to think about having a 16 GB datafile, through. How long to get
> tht back from tape?
>
> hth,
>
> Paul
>
> -------- Original Message --------
> Date: Fri, 10 Nov 2000 07:11:29 -0800
> Reply-To: ORACLE-L_at_fatcity.com
> Organization: Fat City Network Services, San Diego, California
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>
>
>
> 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:
> 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
Received on Fri Nov 10 2000 - 13:21:47 CST
