• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

status in v$rollstat is offline

Sir,
In my database the select status from v$rollstat is offline
Is there any steps to make it online
0
dbaseek
Asked:
dbaseek
  • 2
1 Solution
 
Shaju KumbalathCommented:
check the output

SELECT name,status FROM v$rollstat r,v$rollname n WHERE r.usn = n.usn;
0
 
Shaju KumbalathCommented:

select value from v$parameter where name = 'undo_tablespace' ;
note down that name;
alter system set undo_tablespace='';
check

SELECT name,status FROM v$rollstat r,v$rollname n WHERE r.usn = n.usn;

alter system set undo_tablespace='<put undo table space name>';  
 
 SELECT name,status FROM v$rollstat r,v$rollname n WHERE r.usn = n.usn;
 
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now