Dropping Database

SQL> drop database ;
drop database
*
ERROR at line 1:
ORA-01507: database not mounted

SQL> @C:\oracle\product\10.2.0\admin\jdb2\udump\ctrl.sql

Control file created.

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted

SQL> drop database;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode

SQL> alter database enable restricted mode;
alter database enable restricted mode
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>