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
