Difference between revisions of "Delete a database on Windows"
From dbawiki
(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...") |
|||
| Line 13: | Line 13: | ||
oradim -delete -sid <SID> | oradim -delete -sid <SID> | ||
*Clean up database files: | *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 | Delete the files and directories shown by above queries | ||
Revision as of 14:45, 1 December 2011
- 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
