Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop-schema

771625May 11 2010 — edited May 11 2010

I am new to oracle.could some one help me how to drop an oracle schema?

This is what i have done
Connected to the oracle instance.Then from googling i have DROP DATABASE command.
I done this got error
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

while doing shutdown says insufficient privileges.
i done grant all privileges to user
then also i could not drop the schema

Give me Suggestions please
Thanks

This post has been answered by Girish Sharma on May 11 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2010

Added on May 11 2010

#general-database-discussions

14 comments

3,602 views