Re: Recompile schema

From: Tapan Trivedi <tapan.trivedi_at_abbnm.com>
Date: Mon, 04 Oct 1999 09:19:43 -0500
Message-ID: <37F8B77F.FE40FCAC@abbnm.com>

Richard,
Increase the size of your rollback segments. You probably could make a LARGE rollback segment and then do a set transaction use rollback LARGE rbs .

Tapan

Richard Platt wrote:
>
> Hi
>
> I have been using the dbms_utility.recompile_schema procedure, but keep
> getting errors about 'snapshot too old' in one of my rollback segments, even
> tough I set transaction at the start of the script. (Why is it using
> rollback anyway ?)
>
> Have anybody had this problem, what are the workrounds ?
>
> Any help appreciated.
>
> --
> Regards Richard Platt
> rick.platt_at_btinternet.com

Received on Mon Oct 04 1999 - 09:19:43 CDT