patternMinor
Deleting an Oracle database without connecting to it?
Viewed 0 times
deletingwithoutconnectingdatabaseoracle
Problem
I have two databases which were created using
I made some changes in the second database, and I can't login to that database anymore, and, of course, I can't delete it by using
I am using Centos 5 and Oracle 10g Release 2.
How can I delete a database manually without impacting another dababase?
dbca.I made some changes in the second database, and I can't login to that database anymore, and, of course, I can't delete it by using
dbca.I am using Centos 5 and Oracle 10g Release 2.
How can I delete a database manually without impacting another dababase?
Solution
From René Nyffenegger's blog:
Since 10g, It is possible to drop a database in Oracle 10g with the new SQL statement
The command gets rid of datafiles online redo log files, controlfiles and spfile…
Requirements:
. database must be closed
. exclusively mounted
. restricted
If you do not have a password, you should still be able to connect from the console, eg:
Since 10g, It is possible to drop a database in Oracle 10g with the new SQL statement
drop database…The command gets rid of datafiles online redo log files, controlfiles and spfile…
shutdown abort;
startup mount exclusive restrict;
drop database;
exitRequirements:
. database must be closed
. exclusively mounted
. restricted
If you do not have a password, you should still be able to connect from the console, eg:
sqlplus / as sysdbaCode Snippets
shutdown abort;
startup mount exclusive restrict;
drop database;
exitsqlplus / as sysdbaContext
StackExchange Database Administrators Q#44035, answer score: 3
Revisions (0)
No revisions yet.