That would delete the instance AND the database. To "delete the instance" type SHUTDOWN ABORT. The "instance", after all, is just the SGA and background processes.
(unless you are in 9i, and then you just think real hard, and it figures it out for you. ) ;-) Yours in Picking Nits, etc. -----Original Message----- Sent: Thursday, October 18, 2001 1:01 PM To: Multiple recipients of list ORACLE-L To delete an instance, shutdown the instance and remove all its control, log and database files. To do it properly, remove also all its entries in SQL*Net(Net8) parameter files. That's all. -----Message d'origine----- De : Seema Singh [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 18 octobre 2001 18:41 À : Multiple recipients of list ORACLE-L Objet : how to delete instance? Hi WHich way is better way to delete Instance? Means shutdown instance/delete all reference files or remove thru dbassist mode and then delete reference files? Thanks -Seema _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: ALEMU Abiy 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: Mohan, Ross 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).
