| database open in exclusive mode ? [message #54637] |
Mon, 25 November 2002 06:14  |
jagjeet singh
Messages: 16
Registered: October 2001
|
Junior Member |
|
|
hello Friend ...
i have some question ... if u can solve .. pls tell me .. i m using 9.0.1 9i/R1
whenever i issued this command ..
1. alter database close ;
and after that
alter database open ;
its give message database allready open by instance ..
but when i select any query it gives error ...
2. some time after dismount the database ..
when i tries for mount the database ...
"database could not open in exclusive mode "
3. if my ( any user ) default tablespace is off line
then how can i drop a table ..
if it will only update system data dictionary
then where goes data .
thanx friend ... i m new in dba .. pls explain if u have time ....
|
|
|
|
| Re: database open in exclusive mode ? [message #54654 is a reply to message #54637] |
Mon, 25 November 2002 21:20  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
1. I did not know there was an ALTER DATABASE CLOSE command. I always thought I had do a SHUTDOWN in order to close the datbase.
What error does it give?
2. What OS are you on? I have seen this problem in a Windows environment several times. I have been able to resolve the problem by shutting down the db and dropping and recreating the service (using oradim command). but this was on windows.
3.When you drop a table, oracle does not erase the data. Oracle simples marks that space as being available in the data dictionary. So when Oracle needs the space, it will overwrite the data then. But once you drop a table, even though the data is not erased, the data is gone for all practical purposes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
