RE: Large exports on NT

Yeah but what if you only need to recover one datafile? I am just playing devils advocate. If you can split up the 8 files on separate disks it could actually be an advantage but otherwise it wouldn't.

-----Original Message-----
From: Michael Ray [mailto:Michael.Ray_at_trw.com] Sent: Friday, November 10, 2000 10:23 AM To: Multiple recipients of list ORACLE-L Subject: Re: Large exports on NT

I thought the NTFS limit was much larger than that (at least 2TB). We have a 16GB datafile that we have exported and imported on SP5. Why would it be any faster to get 8 2GB datafiles from tape for a tablespace than 1 16GB one?

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> drake_at_psscorp.com 11/10/00 10:15AM >>>
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Ray
  INET: Michael.Ray_at_trw.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).