| Drop database in mount state [message #618312] |
Thu, 10 July 2014 10:25  |
|
|
Hi ,
When we drop a database using following steps in sqlplus tool, why do we drop it in mount state and not in open or nomount state.
Can you please explain ?
connect SYS/<syspwd> as SYSDBA
alter system set cluster_database=false scope=spfile;
shutdown immediate
startup mount restrict
drop database;
exit;
Regards,
Srini
[Updated on: Thu, 10 July 2014 10:27] Report message to a moderator |
|
|
|
| Re: Drop database in mount state [message #618313 is a reply to message #618312] |
Thu, 10 July 2014 10:31  |
John Watson
Messages: 8461
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You couldn't drop it in nomount mode, because in nomount you haven't connected to the database. You don't even know where it is. So the command would have to mount the database first.
Similarly, you couldn't drop it in open mode because, well, everything is open. So the command would have to close the database first.
Seems reasonable to me.
|
|
|
|
| Re: Drop database in mount state [message #618314 is a reply to message #618313] |
Thu, 10 July 2014 10:42 |
|
|
Hi John,
Firstly ,i thank you for your quick response.I am not surprise to see your quick answer  because i know this is how orafaq moderators provide answers to us.
Quote:Similarly, you couldn't drop it in open mode because, well, everything is open
Well it would be good,if you could explain why we cannot drop a database when it is in open state ?
What would be the impact if we try to drop a database when it is in open state ?
Regards,
Srini
[Updated on: Thu, 10 July 2014 10:45] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
