Drop database schema in mount

675346

Hi!

Is it possible to drop a database schema before before the database is opened (ie. drop schema when mounted)?

Edited by: user7066552 on Dec 12, 2008 6:39 AM

153119

Hi,

The drop user statement obviously requires an open database, as it needs to modify the datadictionary.

--
Sybrand Bakker
Senior Oracle DBA

561093

Hi,

You can test it yourself. Its pretty easy.

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> drop user test;
drop user test
*
ERROR at line 1:
ORA-01109: database not open


SQL>

Regards

Asif Momen
http://momendba.blogspot.com

675346

Ok, thank's a lot for your help!

Pavan DBA

hi oracle will updates data dictionary for every DDL statement issued by the user (in other cases also it will update). this oracle can be performed only when the database is in open state. so you can't drop a schema(user) when the database is in mount state.