Just remember to make the change in your init.ora file if you want it to be permanent. Otherwise, the next time you bounce the DB the destinations will revert to whatever they are in that file.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"K Gopalakrishnan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/13/2002 01:14 PM PST
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
bcc:
Subject: RE: Changing dump destinations in init.ora
No need to bounce the instance. You can dynamically chance the location
using ALTER SYSTEM command.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-----Original Message-----
Thomas F
Sent: Wednesday, February 13, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Nope. Create the new directory, change them in the file and bounce the
instance.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, February 13, 2002 3:19 PM
To: Multiple recipients of list ORACLE-L
Do I have to rebuild the controlfiles if I change any of the dump
destinations
in my oracle init.ora files.
Thanks
Darren
----------------------------------------------------------------------------
----------------------------------------------
Darren Browett P.Eng This message
was transmitted
Data Administratorusing 100%
recycled electrons
Information and Communication Technology
City of Coquitlam
P:(604)927 - 3614
E:[EMAIL PROTECTED]
----------------------------------------------------------------------------
-----------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
