Drop database

C:\Documents and Settings\robin>set oracle_sid=10g2t

C:\Documents and Settings\robin>sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 16 10:07:57 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

_USER'@'_CONNECT_IDENTIFIER >
SYS@10g2t >
SYS@10g2t >
SYS@10g2t > select name from v$database;

NAME
---------
10G2T

 

SYS@10g2t > drop database;
drop database
*

ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

 

SYS@10g2t > startup mount exclusive;
ORACLE instance started.

Total System Global Area  327155712 bytes
Fixed Size                  1248792 bytes
Variable Size             117441000 bytes
Database Buffers          201326592 bytes
Redo Buffers                7139328 bytes
Database mounted.

 

SYS@10g2t > drop database;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode

 

SYS@10g2t > alter system enable restricted session;

System altered.

SYS@10g2t > drop database;
ERROR:
ORA-01034: ORACLE not available

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
@ >

 

key: startup mount exclusive;

alter system enable restricted session;