On Wed, 23 Jul 2003, zhu chao wrote:
> Hi, guang:
> I have two questions:
> 1. Why create rbs on lmt tablespace and later drop it again? Just do
> step 1-7 and it is ok. Or maybe you need to update your init file, but you
> can also offline old rbs01 and create new rbs01 on lmt, and so o
Hi!
Great you got everything working fine.
Just a note, that in truly high available systems, it's reasonable to wait
until all long-running queries, which were started before offlining rollback
segments, have ended before you actually drop the offlined rollback
segments. Oracle is able to read o
Hi, guang:
I have two questions:
1. Why create rbs on lmt tablespace and later drop it again? Just do
step 1-7 and it is ok. Or maybe you need to update your init file, but you
can also offline old rbs01 and create new rbs01 on lmt, and so on.
2. If you have dmt rollback segment in pro
cc:
Sent by: Subject: Re: convert RBS tablespace
from DMT to LMT (Oracle 8173) steps?
I just finished this conversion by using Ron's method: looping through
RBS00X (X from 1 to 6):
alter rollback segment RBS00X offline;
drop rollback segment RBS00X;
create rollback segment RBS00X storage(initial 2048K next 2048K minextents
2 ) tablespace RBSlmt;
alter rollback segment RBS00X onli
Oracle will not let you drop a rollback segment if there are active transactions using
it. However, it will allow you to offline the segment and no new transactions can use
it. I don't recall the exact status in v$rollstat, but I think it may say pending
offline.
As for the commit across cursor
DENNIS WILLIAMS
@LIFETOUCH.COM> cc:
Sent by: Subject: RE: convert RBS tablespace
from DMT to LMT (
I see. Thanks.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online t
Guang
Yes, I noticed that after I posted my reply. Typically if this was a
production system I would tend to create new rollback segments, online the
new segments, offline the old segments, then change the init.ora. Sometime
later I would drop the old segments and tablespace, maybe after a back
quot;Guang Mei" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/23/2003 10:24 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:convert RBS tablespace
Do I need to? I thought after all the steps I still have the same rollback
segment names (RBS01-06). The only difference is they will be in LMT now.
Guang
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Guang - Don't for
ase respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: convert RBS tablespace from DMT to LMT (Oracle 8173)
steps?
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 prod
2003 10:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: convert RBS tablespace from DMT to LMT (Oracle 8173) steps?
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT
Guang - Don't forget to update your init.ora!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Hi:
I need to convert RBS tablespace (used for rollback segments)
Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the
steps I am thinking of taking:
1. create a new rbslmt tablespace
2. create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in
rbslmt t
15 matches
Mail list logo
