Drop Database

Contents:- Drop Database

Drop Database By using Drop Database SQL Statement

Conditions:

          The database must be mounted and closed

          The database must be mounted exclusively

          The database must have been started in restricted mode.

Example:

Steps

  1)   SQL> Startup Restrict force mount

  2)   Sql>   Drop Database;

Notes:- drop database statement delete all your data files, control files, redo log files and initialization parameters. drop database statement has no effect on archived log files nor does it have any effect on copies of backup of the database.