Drop Data Base from oracle
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 must be closed,
exclusively mounted,
restricted
