Re: undo tablespace and rollback segments in oracle9i

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Wed, 30 Jul 2003 06:49:34 -0800
Message-ID: <F001.005C7D50.20030730064934@fatcity.com>

Your question is not very clear. Sorry.

Can you please post results of following commands?

Thanks.

• Kirti

SQL> show parameter undo

SQL> select segment_name, tablespace_name from dba_rollback_segs;

SQL> select a.usn, a.name, b.status
  2 from v$rollname a,
  3 v$rollstat b
  4 where a.usn = b.usn;

• A.Bahar_at_billing-components.com wrote:

> I use manual managed undo tablespace but there are some system named rollback segments on that
> tablespace ( I did not created them ) and they can not be dropped.
> What are they , how can I drop them.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <A.Bahar_at_billing-components.com
> INET: A.Bahar_at_billing-components.com
>
>

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: kirtikumar_deshpande_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jul 30 2003 - 09:49:34 CDT