Delete a database on Windows
From dbawiki
- Check where the ORACLE_HOME for this instance is:
Start:Run... services.msc Double click on OracleService<SID>, the first part of "Path to executable" is the home
- Find location of files to delete:
Connect as sys and:
select name from v$datafile; select member from v$logfile; show parameter control show parameter dump show parameter archive_dest
- Stop the services related to the instance:
set ORACLE_HOME=<oracle home> oradim -delete -sid <SID>
- Clean up database files:
delete %ORACLE_HOME%\database\PWD<SID>.ora and and pfile, spfile and .dat files Delete the files and directories shown by above queries