Message-Id: <10513.107162@fatcity.com> From: Alex Hillman Date: Tue, 30 May 2000 15:29:33 -0400 Subject: RE: How to change the value of MAXDATAFILES of a running instance This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFCA6D.625FD170 Content-Type: text/plain; charset="iso-8859-1" I understood his question as if we can do it without bouncing the database. I do not know how without not supported manipulation with DD and controlfiles. Alex Hillman -----Original Message----- From: Deepak Sharma [mailto:sharmakdeep@yahoo.com] Sent: Tuesday, May 30, 2000 2:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to change the value of MAXDATAFILES of a running 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 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@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@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@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@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). ------_=_NextPart_001_01BFCA6D.625FD170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: How to change the value of MAXDATAFILES of a running = instance ?

I understood his question as if we can do it without = bouncing the database. I do not know how without not supported = manipulation with DD and controlfiles.

Alex Hillman

-----Original Message-----
From: Deepak Sharma [mailto:sharmakdeep@yahoo.com]<= /FONT>
Sent: Tuesday, May 30, 2000 2:56 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How to change the value of MAXDATAFILES = of a running
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@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@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@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@yahoo.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San Diego, California     &n= bsp;  -- Public Internet access / Mailing Lists
---------------------------------------------------------------= -----
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@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 =