Re: Proper way of deleting an Oracle database?

From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1995/04/17
Message-ID: <3mtms1$1fc_at_sulawesi.lerc.nasa.gov>#1/1


Shut down the data base. Kill off any malingering SQL*Net processes. Then simply delete all files associated with the data base. These can be found (prior to shutdown) by inspecting (pick one - I can't remember which) V$DATAFILE, V$FILESTAT, or DBA_DATAFILES. Control files will be cited in the init.ora file, and the location of dumps and traces can be found there as well. Received on Mon Apr 17 1995 - 00:00:00 CEST

Original text of this message