Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: Max size of a datafile in oracle

Re: RE: Max size of a datafile in oracle

From: surendra tirumala <>
Date: 11 Sep 2000 19:34:33 -0000
Message-Id: <>

Hi Uma,
The max size of df is decided by the way u respond to the option while installing OS.It clearly asks whether to go for managing larger files(>2GB), while installing. Suren

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.

Uma Shankar

Get Your Free Email At,

For fabulous shopping deals visit:

 From: "Tom Pall" <>
 Date: Mon, 11 Sep 2000 15:36:52 -0500
 Subject: Re: Oracle 8.0.5

If you upgrade to 8, then upgrade to 8.0.6. It's supported, for now.

The best I've heard about Oracle 8i is that it is no buggier than Oracle 8. Of course it's got a bunch more features and those have bugs in them.

I do not have any money making databases running at 8.1.6 yet, as I am using 8.1.6 for reporting and non-critical databases, just to get my feet wet. I'm eagerly awaiting 8.1.7, as the bugs in 8.1.6 which prevent me from running in CBO are slated to be fixed in 8.1.7.

We're a two DBA company and we average opening up two TARs a week, all on problems with 8.1.6. Because of this, my production databases are *NOT* going to 8.1.6 anytime soon. If we are forced to upgrade by Oracle Support, we'll upgrade production databases to 8.0.6 until the glaring problems we face in 8.1.6 are fixed, at least.
----- Original Message -----
From: <>
To: Multiple recipients of list ORACLE-L <> Sent: Monday, September 11, 2000 10:03 AM Subject: Oracle 8.0.5

> We have a mission-critical app running on RDBMS: AIX: 4.2.1
> Our vendor has sent us a proposal to upgrade the RDBMS to 8.0.5. I know there
> are releases beyond this (e.g. 8.0.5.x, 8.0.6.x, 8.1.x). But after searching
> Metalink it is not clear to me that higher releases are any more bug-free than
> 8.0.5. While higher releases fix 8.0.5 bugs, they seem to introduce additional
> bugs. Therefore instead of going to the highest release, my optimal strategy
> (keep in this mind this app is mission-critical) should be to go to the lowest
> release since in those releases Oracle Tech Support will have had the most
> time/experience in fixing known problems.
> Any comments on 8.0.5 vs. higher versions? Comments on my upgrade strategy?
Received on Mon Sep 11 2000 - 14:34:33 CDT

Original text of this message