RE: How to change the value of MAXDATAFILES of a running instance

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Wed, 31 May 2000 14:28:15 +0200
Message-Id: <10514.107261@fatcity.com>

I think that you mess up the db_files parameter and the MAXDATAFILES parameter !!!

-----Message d'origine-----
De: Jain, Akshay [mailto:Akshay.Jain_at_cit.com] Date: mardi 30 mai 2000 21:53
=C0: Multiple recipients of list ORACLE-L Objet: RE: How to change the value of MAXDATAFILES of a running = instance

But I was able to change the value in the init.ora file, and bounce the database. Too risky?

Also, any opinions on preferences as to altering files to be larger vs. adding datafiles to tablespaces?

Thanks.

Akshay Jain

mailto:Akshay.Jain_at_cit.com                     =20
_______________________

-----Original Message-----
Sent: Tuesday, May 30, 2000 2:56 PM
To: Multiple recipients of list ORACLE-L instance ?

You'll have to recreate the control file.

o Alter database backup controlfile to trace o Edit the trace file generated in UDUMP and increase the MAXDATAFILES
o Shutdown database
o Cold Backup database
o Run the Create controlfile script

For details, let me know

Deepak
- ALEMU Abiy <abiy.alemu_at_criltechnology.com> wrote:
  > Is there somebody who knows how to change the
  > MAXDATAFILES parameter value
  > of a running database ? If so, I'm really very
  > grateful to anyone who can
  > explain me.
  > =20
  > Thank you friends !!!
  > --=20
  > Author: ALEMU Abiy
  > INET: abiy.alemu_at_criltechnology.com
  >=20
  > 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).

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/
--=20
Author: Deepak Sharma
INET: sharmakdeep_at_yahoo.com

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). --=20
Author: Jain, Akshay
INET: Akshay.Jain_at_cit.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------