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

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 30 May 2000 15:00:38 -0500
Message-Id: <10513.107174@fatcity.com>

I have modified the MAXDATAFILES parameter both up and down by just modifying the init parameter and bouncing the instance. Never had a problem.

Ron Smith
Database Administration
rlsmith_at_kmg.com

-----Original Message-----
From: Jain, Akshay [mailto:Akshay.Jain_at_cit.com] Sent: Tuesday, May 30, 2000 2:53 PM
To: Multiple recipients of list ORACLE-L Subject: 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

---

-----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.
    >
    > Thank you friends !!!
    > --
    > Author: ALEMU Abiy
    > INET: abiy.alemu_at_criltechnology.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).
    

    ---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

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

Received on Tue May 30 2000 - 15:00:38 CDT