| Bishal |
Posted: Apr 29, 2008 06:53:16 AM |
Total Post: 160
Joined: Apr, 2008
|
how to bring read only tablespace in a write mode..
I tried bringing it online but it still shows the status as read-only..? |
|
|
GOPU |
| Posted: Apr 29, 2008 06:56:36 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
ALTER TABLESPACE <tablespace_name> READ WRITE;
|
|
|
|
|
Murtuja |
| Posted: Apr 29, 2008 06:58:44 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
ALTER TABLESPACE <tablespace_name> READ WRITE;
Then execute this query
SELECT tablespace_name, status FROM dba_tablespaces;
|
|
|
|
|
Bishal |
| Posted: Apr 29, 2008 07:01:12 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
|
|
|
|
Gitesh |
| Posted: Apr 29, 2008 07:01:59 AM | |
|
Total Post: 322
Joined: May, 2005
|
Check any datafile is lying of same tablespace in RECOVERY MODE.... from v$recover_file. If yes then before bring read/write recover it and bring read write mode.
|
|
|
|
|
Napster |
| Posted: Apr 30, 2008 03:16:56 AM | |
|
Total Post: 24
Joined: Apr, 2008
|
Hi,
Good one Gitesh...Please follow the recovery (if needed) before bringing any datafile in READ/WRITE mode
Cheers
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |