Dropping a database

Dropping a database is nothing more than deleting all physical database files. These files include all datafiles, control files and redo logs.

• Locate all physical database files

    SELECT file_name FROM dba_data_files;
    SELECT name      FROM v$controlfile;
    SELECT member    FROM v$logfile;

• Shutdown the database (abort)

    SVRMGRL> SHUTDOWN ABORT;

• Remove all of the files from the server
  
  • UNIX - use the "rm" command
  • NT - use the "del" command