| sudheer pai |
Posted: May 22, 2007 12:02:57 AM |
Total Post: 33
Joined: Feb, 2007
|
hi
to all dba experts..
pls tell me..
" is there any way to switch my database from read only to read write with out shuting down the database."
pls reply fast.. |
|
|
dipali |
| Posted: May 22, 2007 06:16:30 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
using alter database statement..
i.e.
don't shutdown the database, just close it then
alter database open read write.
|
|
|
|
|
sudheer pai |
| Posted: May 24, 2007 12:17:04 AM | |
|
Total Post: 33
Joined: Feb, 2007
|
thanks but how do u do it.. more in detail pls
|
|
|
|
|
dipali |
| Posted: May 24, 2007 12:58:03 AM | |
|
Total Post: 31
Joined: Dec, 2006
|
1)Close the database, (not shut down)
i.e. alter database close
2)Open it in read write mode..
i.e. alter database open read write
Regards..
Dipali
|
|
|
|
|
manu |
| Posted: May 28, 2007 09:05:48 AM | |
|
Total Post: 4
Joined: May, 2007
|
Sorry but after closing my database with this statement
alter database close
my system donot get to open state using
alter database open read write.
it throws an error saying
ORA-16196: database has been previously opened and closed.
plz reply
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |