|
-
One thing that seems to me is that the previous undo tablespace still contains active undo segments that may be referred in future. Isn't it?
Y dont u check using v$rollstat and v$rollname
SELECT a.name,b.status
FROM v$rollname a, v$rollstat b
WHERE a.name IN ( SELECT segment_name
FROM dba_segments)
AND a.usn = b.usn
/
Last edited by mahajanakhil198; 07-16-2009 at 07:33 AM.
lucky
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote