Pages

2011-03-30

Drop Oracle Database

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:
sqlplus / as sysdba
shutdown abort;
startup mount exclusive restrict;
drop database;
exit

No comments:

Post a Comment