Dropping Database

Dropping a Database 

Datafiles, redo log files, and control files are removed automatically. Alert log and parameter file are not deleted.
CONNECT sys/sys_passwd AS SYSDBA
SHUTDOW IMMEDIATE
STARTUP RESTRICT MOUNT
SELECT name FROM v$database;
DROP DATABASE;