RE: Max size of a datafile in oracle

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).