Oracle-L: RE: undo tablespace and rollback segments in oracle9i

From: <A.Bahar_at_billing-components.com>
Date: Wed, 30 Jul 2003 07:29:48 -0800
Message-ID: <F001.005C7D71.20030730072948@fatcity.com>

hi ,
please look attached file ;

-----Original Message-----
Sent: Wednesday, July 30, 2003 3:52 PM
To: ORACLE-L_at_fatcity.com
Cc: Bahar, Arslan

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

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_001_01C356A7.690573E1--

-- 
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

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 - 10:29:48 CDT