Database Administration (MOSC)

MOSC Banner

drop the whole datase

edited Mar 11, 2010 10:46PM in Database Administration (MOSC) 14 commentsAnswered
 could you please anybody let e know how to drop the whole database.

I have trie using the follwoing,

dropdatabase.sql file has the follwoing commands

shutdown abort;
startup mount exclusive restrict;
drop database;
exit

and i tried running from command prompt as

C:\>sqlplus  username/password @C:\dropdatabase.sql

but i got the following error

ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

pls tell me the correct steps to drop the database.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center