Home

Welcome to DBA World!
Best Corporate Real Time Training on Oracle 12C/11G/10G DBA by Expert 10+yrs Exp
Call us for Enquiries : 9550720899

Drop Database on 10g

Drop database in Oraclein10g


Since 10g, It is possible to drop a database in Oracle 10g with the new SQL statement drop database. The command gets rid of datafiles online redo log files, controlfiles and spfile


Requirements
•database must be closed,
•exclusively mounted,
•restricted

startup mount exclusive restrict;

drop database;

exit