Re: Roback messages

From: Jeff Smelser <tradergt_at_bigfoot.com>
Date: Tue, 22 Feb 2000 12:21:43 -0600
Message-ID: <Pine.LNX.4.10.10002221220590.12408-100000@server.smelser.org>

On Tue, 22 Feb 2000, Sybrand Bakker wrote:

> Apparently the rollback segment is not online.
> either issue a select segment_name, status from dba_rollbck_segs or use
> v$rollstat to verify.
> If it is not online issue alter rollback segment <segment_name> online and
> verify init<sid>.ora where it should appear in the line
> rollback_segments=(<segmentname1>,<segmentname2>), assuming your didn't
> issue the command create public rollback segment before, in which case this
> all shouldn't be necessary.

You are correct, it was not online. I issued the alter statement and all is well.. Thanks! :)

Jeff Received on Tue Feb 22 2000 - 12:21:43 CST