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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
