Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Large exports on NT

Re: Large exports on NT

From: Michael Ray <Michael.Ray_at_trw.com>
Date: Fri, 10 Nov 2000 10:21:25 -0800
Message-Id: <10676.121759@fatcity.com>


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? Received on Fri Nov 10 2000 - 12:21:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US