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: Murugaian Adi <adi_at_MarketingAssociates.com>
Date: Sun, 10 Sep 2000 14:49:55 -0400
Message-Id: <10615.116602@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C01B57.E98DCB24
Content-Type: text/plain;

        charset="windows-1252"

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-----
From: Uma Sankara_Sivadanam [mailto:UmaSankara_Sivadanam_at_satyam.com] Sent: Sunday, September 10, 2000 1:26 PM To: Multiple recipients of list ORACLE-L Subject: Max size of a datafile in oracle

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
Uma Shankar

------_=_NextPart_001_01C01B57.E98DCB24
Content-Type: text/html;

        charset="windows-1252"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<TITLE>Max size of a datafile in oracle</TITLE>

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=640584818-10092000>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</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Uma Sankara_Sivadanam   [mailto:UmaSankara_Sivadanam_at_satyam.com]<BR><B>Sent:</B> Sunday, September 10,   2000 1:26 PM<BR><B>To:</B> Multiple recipients of list   ORACLE-L<BR><B>Subject:</B> Max size of a datafile in   oracle<BR><BR></FONT></DIV><BR>
  <P><FONT face=Arial color=#0000ff size=2>Hi List,</FONT><FONT face=Arial>   </FONT><BR><FONT face=Arial color=#0000ff size=2>I am not sure whether this   question is put or not in the list.</FONT><FONT face=Arial> </FONT><BR><FONT   face=Arial color=#0000ff size=2>Is there any limit oracle imposes on the size   of a datafile.Somebody said it is 2GB.</FONT><FONT face=Arial>   </FONT><BR><FONT face=Arial color=#0000ff size=2>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.</FONT><FONT face=Arial> </FONT></P>   <P><FONT face=Arial color=#0000ff size=2>Thanx</FONT><FONT face=Arial>   </FONT><BR><FONT face=Arial color=#0000ff size=2>Uma Shankar</FONT><FONT   face=Arial> </FONT></P></BLOCKQUOTE></BODY></HTML> Received on Sun Sep 10 2000 - 13:49:55 CDT

Original text of this message

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