hi , please look attached file ;
-----Original Message----- Sent: Wednesday, July 30, 2003 3:52 PM To: [EMAIL PROTECTED] 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; --- [EMAIL PROTECTED] 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: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
<encoded content removed -- binaries not allowed by ListGuru>