Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding rollback

Re: Adding rollback

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 17 Aug 2004 07:22:34 -0700
Message-ID: <1092752602.70798@yasure>


Howard J. Rogers wrote:

> Daniel Morgan wrote:
>
>

>>bw wrote:
>>
>>
>>>I have inherited a 9.2.0 database where the only rollback segments
>>>that exist are what was created for SYSTEM.  Can I get away with
>>>adding the needed rollback segments (RBS01... etc.) to the init.ora,
>>>creating them in the existing RBS tablespace?  Once this has been
>>>completed do I then bounce the instance so they are recognized via the
>>>init.ora?
>>
>>SELECT segment_name
>>FROM dba_undo_extents;
>>
>>Unless this query returns no rows I'd suggest you get yourself
>>current with the 9i and 10g docs.
>>

>
>
>
> Now why would you get him to query that view and in that way?
>
> For meaningful output, you'd surely want him to select DISTINCT segment_name
> from dba_undo_extents.
>
> But then if you were going to do that, you might as well simply select
> segment_name from dba_rollback_segs... a view which is just as 'current' in
> 9i and 10g as any with the buzz-word 'undo' in it.
>
> Regards
> HJR
Because it was the first query that came to mind that would quickly indicate that there were undo segments. No other reason. And it pointed the OP to the appropriate data dictionary view.
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Aug 17 2004 - 09:22:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US