Solved

status in v$rollstat is offline

Posted on 2008-10-07
2
475 Views
Last Modified: 2013-12-18
Sir,
In my database the select status from v$rollstat is offline
Is there any steps to make it online
0
Comment
Question by:dbaseek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 15

Expert Comment

by:Shaju Kumbalath
ID: 22666479
check the output

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

Accepted Solution

by:
Shaju Kumbalath earned 500 total points
ID: 22666506

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question