alter tablespace test_tbs read only hangs [message #320863] |
Fri, 16 May 2008 08:43  |
TLegend33
Messages: 203 Registered: March 2005
|
Senior Member |
|
|
I created a partitioned test tablespace 'test_tbs' to test out transportable tablespaces. However, when I issue :
SQL> alter tablespace test_tbs read only;
My session just hangs. I had this running overnight and it did not complete this morning. There were no corresponding messages in the alert.log either. There are no active transactions affecting this tablespace, why would this seemingly simple task hang?
Thanks.
|
|
|
|
Re: alter tablespace test_tbs read only hangs [message #320875 is a reply to message #320866] |
Fri, 16 May 2008 09:32   |
TLegend33
Messages: 203 Registered: March 2005
|
Senior Member |
|
|
That's interesting. However, the only objects in this tablespace are my test table partitions:
1* select segment_name, segment_type, bytes/1024/1024 from dba_segments where tablespace_name = 'TEST_TBS'
SQL> /
SEGMENT_NAME SEGMENT_TYPE BYTES/1024/1024
------------------------------ ------------------ ---------------
SENT_TEST TABLE PARTITION 3392
SENT_TEST TABLE PARTITION 3200
SENT_TEST TABLE PARTITION 3200
I've issued commits and also exited/re-entered the session. Shouldn't that commit any uncommitted transactions? Could it have anything to do with the fact that during the load of my test data, I set the tablespace to 'no logging'?
|
|
|
|
|