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
The scenario you describe is not consistent with manual undo. Was the database
created/started with automatic undo and you have switched to manual?
[EMAIL PROTECTED] wrote:
I use manual managed undo tablespace but there are some system named rollback
segments on that
tablespace ( I did
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
yes . What should i do
-Original Message-
Sent: Wednesday, July 30, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
The scenario you describe is not consistent with manual undo. Was the database
created/started with automatic undo and you have switched to manual?
[EMAIL
If you are now running in manual undo mode and have created rollback segments, you can
remove the undo segments. Verify that the segments are offline and you are not using
them. Then drop the undo tablespace. This is the only way to get rid of them.
[EMAIL PROTECTED] wrote:
yes . What should
Your attachment was removed by the list server.
However, your direct e-mail to me had the following:
SQL show parameter undo ;
NAME TYPEVALUE
--- --