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: Max size of a datafile in oracle

Re: Max size of a datafile in oracle

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Mon, 11 Sep 2000 09:06:18 -0400
Message-Id: <10616.116625@fatcity.com>


However, I is the limit for rman backup sets and .dmp files (without doing special things) so you should take this into consideration. RBG

> 2GB size is not oracle limit.... it depends on your OS, but better to have
> less than 2GB, this will help to manage the datafile
>
> -----Original Message-----
> Sent: Sunday, September 10, 2000 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> Hi List,
> I am not sure whether this question is put or not in the list.
> Is there any limit oracle imposes on the size of a datafile.Somebody said
it
> is 2GB.
> Can any one of you tell me the max datafile size possible and also the
> oracle recommended size.It is for Oracle 8.1.5.
>
> Thanx
Received on Mon Sep 11 2000 - 08:06:18 CDT

Original text of this message

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