Drop Data Base from oracle DROP USER databasename cascade; //Oracle It is possible to drop a database in Oracle with the new SQL statement drop database. The command gets rid of datafiles online redo log files, controlfiles and spfile. Example to use the command shutdown abort; startup mount exclusive restrict; drop database; exit Requirements database [...]