# How to drop database in oracle 10g
oracle database can be
dropped in oracle 10g . the procedure is as follows
1.$sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Feb 18 20:15:26 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL connect / as sysdba
Connected to an idle instance.
SQL shutdown abort;
ORACLE instance shut down.
SQL startup nomount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 790352 bytes
Variable Size 174321840 bytes
Database Buffers 436207616 bytes
Redo Buffers 1048576 bytes
2.SQL> alter database mount exclusive;
Database altered.
3.SQL> alter system enable restricted session;
System altered.
4.SQL> drop database;
Database dropped.
Disconnected from Oracle Database 10g Release 10.1.0.3.0 - Production
5. SQL >exit