Showing posts with label Drop Database in Oracle 10g. Show all posts
Showing posts with label Drop Database in Oracle 10g. Show all posts

Saturday, April 2, 2011

Drop Database in Oracle 10g


     It has become easier to drop a database from Oracle 10g. Use the DROP DATABASE command to drop the database. It removes the datafiles,redologs, controlfiles and init parameter files.

$ sqlplus / as sysdba
SQL> Shutdown immediate;
SQL> Startup Mount Exclusive Restrict;
SQL> Drop Database;