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 wh
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
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 s
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 PROTECTE
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 shoul
Your attachment was removed by the list server.
However, your direct e-mail to me had the following:
SQL> show parameter undo ;
NAME TYPEVALUE
--- --
undo_m