Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segs prob. 7.3.2.3 -> 7.3.3.0

Re: rollback segs prob. 7.3.2.3 -> 7.3.3.0

From: John Durst <jdurst_at_sky.net>
Date: 1997/11/18
Message-ID: <3471F024.F5AFC96D@sky.net>#1/1

There is a parameter you need to set in your init.ora to allow this. I believe it is UNLIMITED_ROLLBACK_SEGMENTS=TRUE, but I wouldn't swear to it. I'm at home
sick so I cannot verify the exact parameter for you.

Dave Brady wrote:

> I've just done this upgrade (on Digital UNIX 4.0B), and now I
> can't open the database:
>
> ORA-01682: rollback segment (2) has unlimited extents
>
> I had created this database with unlimited extents on the rollback
> segments,
> as I wanted something with which I could experiment.
>
> The Oracle7 Server Messages book does not list this error, so
> I have no clue as to how to correct it.
>
> Any help would be appreciated!
> --
>
> Dave Brady FAS Computer Services
> Sr UNIX Sys Admin/Programmer Harvard University
> brady_at_fas.harvard.edu LL1A Science Center
> Phone: (617) 495-1273 1 Oxford Street
> FAX: (617) 495-1210 Cambridge, MA 02138
Received on Tue Nov 18 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US