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

Subject: FW: [Fwd: Re: Large exports on NT]

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 -------- Subject: Re: Large exports on NT Date: Fri, 10 Nov 2000 07:11:29 -0800 From: TCarlson_at_bunge.com 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? Received on Fri Nov 10 2000 - 11:26:17 CST