Message-Id: <10522.108187@fatcity.com> From: Baiju Anthony Date: Thu, 08 Jun 2000 14:17:29 +0530 Subject: Re: Dropping a database under unix I do this to remove a database on solaris : 1. Shut down the instance. 2. Delete all the datafiles, log files, control files of the database. 3. Remove the init{ORACLE_SID} file from $ORACLE_HOME/dbs directory 4. Remove the databases entry from /opt/var/oratab file. 5. Remove the databases entry from $ORACLE_HOME/network/admin/listener.ora file. 6. Remove the databases entry from $ORACLE_HOME/network/admin/tnsnames.ora file. 7. Remove the databases entry from the centrally maintained tnsnames.ora file ( if you have one) Thanks Baiju Oracle DBA MBT, Pune India. dlj wrote: > Use an OS command of rm filename. > > dlj > --- "Mr. Majestic" wrote: > > How do I do this Under svrmgrl on a Solaris? My > > initial databse wasn't propery created and I need to > > go back and recreate it. > > > > I know you have to remove its datafiles, redo log > > files, and all other associated files (control > > files, parameter files, archived log files). > > > > But I don't know how it's done under unix. > > > > ThanksI, new to unix > > Student > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Photos -- now, 100 FREE prints! > http://photos.yahoo.com > > -------- > If you're bored, then visit the list's website: http://www.lazydba.com (updated daily) > to unsubscribe, send a blank email to oracledba-unsubscribe@quickdoc.co.uk > to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk