Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Max size of a datafile in oracle
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
![]() |
![]() |