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

Home -> Community -> Usenet -> c.d.o.server -> Re: Max size for a datafile

Re: Max size for a datafile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 22 Jul 2001 22:21:59 +0200
Message-ID: <995833319.21887.0.pluto.d4ee154e@news.demon.nl> 







"@nnibale" <annibale_at_ifrance.com> wrote in message
news:9jf1ur$vq2$1_at_news4.isdnet.net...


> hi,

>

> I work on a TRU64 - 4.0e  unix server  with oracle 8.04 installed.

> What is the max (or reasonable) size  for a datafile on a unix environment

 ?


>

> Regards

> @nnib

>

>

>

>



on many Unixes the limit is 2G. Beyond that your tablespace is going to
consist of multiple datafiles



Hth,



Sybrand Bakker, Senior Oracle DBA
Received on Sun Jul 22 2001 - 15:21:59 CDT












Original text of this message













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