How to drop a database

hostname.SID$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 10 11:14:43 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

PROD07

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount exclusive restrict

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size                  2140320 bytes

Variable Size             681400160 bytes

Database Buffers         1459617792 bytes

Redo Buffers                4325376 bytes

Database mounted.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options