Delete a database on Windows

From dbawiki
Revision as of 14:34, 1 December 2011 by 127.0.0.1 (talk) (Created page with "*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 locati...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  • 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 the files and directories shown by above queries