| 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
What do you mean by recreating the control files ?
-----Message d'origine-----
De: Steve Boyd [mailto:pimaco_oracle_at_hotmail.com]
Date: mardi 30 mai 2000 19:07
=C0: Multiple recipients of list ORACLE-L
Objet: Re: How to change the value of MAXDATAFILES of a running =
instance
?
I'm surprised that nobody else has answered this one yet, so I'll go =
ahead=20
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
--=20
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). Received on Wed May 31 2000 - 06:09:10 CDT
 |
 |