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: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 12 Sep 2000 10:11:48 -0300
Message-Id: <10617.116718@fatcity.com>


Beware of the RESIZE bug too, that will mess up your data dictionary if = your
files are too large.

Oracle says it will be fixed in Oracle 8.1.7.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
	Sent:	Monday, September 11, 2000 12:03 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: Max size of a datafile in oracle

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

	----- Original Message -----
	To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
	Sent: Sunday, September 10, 2000 3:50 PM



> 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
> Uma Shankar
>
>
--=20 Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Tue Sep 12 2000 - 08:11:48 CDT

Original text of this message

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