RE: tablespace not turning into read only mode

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Fri, 02 Nov 2001 11:17:57 -0800
Message-ID: <F001.003BB955.20011102113036@fatcity.com>

When read only tablespaces first came out, the database had to have no transactions on it before you could to alter a tablespace to read only... In recent releases, Oracle has improved this significantly... But, that does not mean it is clean... If you issue a 'alter tablespace XXX read only', it will hang until all transactions that began before you issued this command finish... Oracle cleanly handles all transactions that start AFTER you issue the command... So, I bet if you look in v$transaction you will see that there are outstanding transactions on the database... Once those finish, your alter will complete...

HTH
Tim

PS - Look at the Concepts guide for more info...

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76965/c03space. htm#1130

-----Original Message-----
[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Friday, November 02, 2001 3:55 AM
To: Multiple recipients of list ORACLE-L

Hi lists,

I am trying to put my tablespace into read only mode(This is to take the transport tablespace export). When i typed

alter tablespace xyz read only;

it is just getting hung. Even after an hour the command is not being executed.

There are no users accessing the objects in that tablespace.

But there are users, using someother objects in other tablespaces.

why oracle cannot turn the tablespace into read only mode?

Thnx and regards
srinivas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Johnston, Tim
INET: TJohnston_at_quallaby.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------