| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to change the value of MAXDATAFILES of a running instance ?
This is a multi-part message in MIME format.
--------------9DD21463FDE381CC5FE663E0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
You are partially correct. You can change the db_files parameter in the init.ora
and bounce the instance, but that parameter must be equal to or less than the
MAXDATAFILES used when creating the database. Once you reach that limit, you must
recreate the controlfile with the new high limit.
HTH,
---Bill Gentry
Stephen J Palmer wrote:
> 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
> also send the HELP command for other information (like subscribing).
--------------9DD21463FDE381CC5FE663E0
Content-Type: text/x-vcard; charset=us-ascii;
name="gentry.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for gentry Content-Disposition: attachment;
begin:vcard
n:Gentry;Bill
tel;fax:612-775-1161
tel;work:612-775-1190
x-mozilla-html:FALSE
org:ALLINA HEALTH SYSTEM
adr:;;1375 Willow Street;Minneapolis;MN;55403;
version:2.1
email;internet:gentry_at_allina.com
Received on Tue May 30 2000 - 14:56:37 CDT
 |
 |