Re: RE: Max datafile size in AIX5.2L

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 02 Jul 2004 08:06:44 -0400
Message-Id: <s0e517af.042@galottery.org>

I hit that problem on a database I inherited. It took some creative = manovering of the tables to free up a needed datafile.=20 I believe you have to rebuilt the controlfile to change the max_datafile = parameter.
Now all the servers I built have 1500 + datafiles even if it is a small = instance.
Ron

>>> premj_at_rediffmail.com 07/02/2004 6:11:39 AM >>>
 
 
Thanx for reminding about MAXDATAFILES Sonja.   we already have 400 (with a max of 512) in oracle 11i environment. Need to think about it.
Regards,
Prem.

On Fri, 02 Jul 2004 Sonja =A9ehovi Ewrote :
>We have AIX 5.2 and Oracle 9.2.0.4 and use datafiles which are bigger =3D
>then 2G.
>It started when we hit maxdatafile number (200), and since it's =3D
>production 7x24 it's not easy to get permission to bounce the database.=3D=
20
>So far, we keep them on 2,5GB
>
>HTH,
>Sonja

Please see the official ORACLE-L FAQ: http://www.orafaq.com=20

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 07:04:01 CDT