Tom, Thank you, you answered my question. I meant that it seem like other NTers use different methods to delete and recreate a db and I thought that the oradim utility was used for that purpose. I need to read up more on the utility I guess.
Oh and I keep forgetting that there are a few of you using unix. :) Ken ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 10:26 AM > Ken, > > If you are just re-creating the database with the same sid, then you do not > need to issue the "ORADIM -delete -sid" command. This command only > interfaces with the NT registry to either insert, modify or delete items in > the registry. > > I'm not sure what you mean when you say " but doesn't seem like anyone else > uses this process.". > > You are correct, in that Unix DBA's do not need to do this, as the NT > registry is specific to NT. Did you mean something else? > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Monday, December 17, 2001 1:05 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > There has been many questions and answers regarding this topic. I have used > oradim -sid -delete then os commands to delete datafiles. Then recreate the > db with scripts with no apparent problems. It has worked just fine, but > doesn't seem like anyone else uses this process. Is there a preferred > method to delete and recreate a database? Am I leaving myself open to other > problems using this process? > > Thanks, > > Ken Hitchcox > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sunrise DBA > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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).