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. BarbourOracle DBA, OCPAISD512-414-1002 "K Gopalakrishnan"
Sent by: root@fatcity.com02/13/2002 01:14 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: bcc: Subject: RE: Changing dump destinations in init.ora No need to bounce the instance. You can dynamically chance the locationusing ALTER SYSTEM command.Best Regards,K GopalakrishnanBangalore, INDIA-----Original Message-----Thomas FSent: Wednesday, February 13, 2002 12:49 PMTo: Multiple recipients of list ORACLE-LNope. Create the new directory, change them in the file and bounce theinstance.Tom MercadanteOracle Certified Professional-----Original Message-----Sent: Wednesday, February 13, 2002 3:19 PMTo: Multiple recipients of list ORACLE-LDo I have to rebuild the controlfiles if I change any of the dumpdestinationsin my oracle init.ora files.ThanksDarren--------------------------------------------------------------------------------------------------------------------------Darren Browett P.Eng This messagewas transmittedData Administratorusing 100%recycled electronsInformation and Communication TechnologyCity of CoquitlamP:(604)927 - 3614E:dbrowett@city.coquitlam.bc.ca-----------------------------------------------------------------------------------------------------------------------------Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Browett, Darren INET: dbrowett@city.coquitlam.bc.caFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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: Thomas.Mercadante@Labor.State.Ny.UsFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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: kaygopal@yahoo.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: DBarbour@austin.isd.tenet.edu
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).
Received on Thu Feb 14 2002 - 00:00:24 CST