What you are referring to is the db_files parameter in init.ora. And that
can be increased to a max of what was set by MAXDATAFILES parameter at the
time the database was created.
However, if you have reached the limit as set by MAXDATAFILES, changing
db_files will not solve the problem and you will have to recreate the
control file with a higher value for MAXDATAFILES. There is no other way
around it, yet!!!
HTH..
> -----Original Message-----
> From: Stephen J Palmer [SMTP:spalmer_at_brk.photronics.com]
> Sent: Tuesday, May 30, 2000 3:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to change the value of MAXDATAFILES of a running
> instance ?
>
> This may not be my place.... but can't you just make the change in the
> init.ora
> file
> and bounce the instance. I don't believe you have to recreate the
> controlfile...
> but
> I believe you will have to bounce the instance to have the new setting
> take
> effect.?
>
> Please let me know if this is not correct.
>
> Thanks
> Steve
>
> Steve Boyd wrote:
>
> > I'm surprised that nobody else has answered this one yet, so I'll go
> ahead
> > and post.
> >
> > You need to recreate the controlfile. Do the good old ALTER DATABASE
> BACKUP
> > CONTROLFILE TO TRACE;
> >
> > Up the parameter in the script this generates, and recreate the
> controlfile.
> > Of course, you will need to take down your database to do this.
> >
> > >From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: How to change the value of MAXDATAFILES of a running instance
> ?
> > >Date: Tue, 30 May 2000 07:56:04 -0800
> > >
> > >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).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Steve Boyd
> > INET: pimaco_oracle_at_hotmail.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).
>
> Stephen Palmer
> Junior Database Administrator
> Photronics Inc.
> 15 Secor Road
> Brookfield, Conn.
> 203.740.5331
> Pager 203-830-0306 or 1-800-706-7109
> mailto:spalmer_at_brk.photronics.com
> Home Number 203.270.8159
> Alpha Pager mailto:spalmer.pager_at_brk.photronics.com
>
>
> --
> Author: Stephen J Palmer
> INET: spalmer_at_brk.photronics.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 - 14:41:49 CDT
