Proper way of deleting an Oracle database?
From: Wendy Cooper <cooper_at_cimage.com>
Date: 1995/04/24
Message-ID: <3nh8l7$lir_at_dgsi.cimage.com>#1/1
Date: 1995/04/24
Message-ID: <3nh8l7$lir_at_dgsi.cimage.com>#1/1
[ Article crossposted from comp.databases.oracle ]
[ Author was Gary Gapinski ]
[ Posted on 17 Apr 1995 12:27:45 GMT ]
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 24 1995 - 00:00:00 CEST