-
Hi guys,
I have 10 partitions in 10 different tablespaces. Only the current partition is being loaded.
I tried to put the tablespace containing the oldest partition into read only mode but it's taking a long time(45 minutes). So I cancelled the operations. I can swear that no object in that particular tablespace is being loader,deleted,updated,etc, so I don't understand why changing the tablespace to read only is taking a long time.
Any idea what's happening?
-
expected behaviour.
read only will take place only if there is no transactions in your database
-
Originally posted by pando
expected behaviour.
read only will take place only if there is no transactions in your database
Pando, what do you mean by that? There is no such requirenment! Further more, there can even be active transactions on the segments of that particular tablespace when you put it in read only mode. The active transactions will be able to complete, but any new transactions on that tablespace will be prevented.
The only restriction are that there must be no active rollback segment in that tablespace and that tablespace is not in backup mode.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|