Re: HELP !!

From: <swhammond_at_my-dejanews.com>
Date: Thu, 19 Nov 1998 23:13:49 GMT
Message-ID: <7328ms$8fn$1@nnrp1.dejanews.com>

With the introduction of Oracle 7.3.3+, this error is generated when the number of extents for the rollback segments is set to unlimited. Prior to this version no error was created. To solve the problem simply insert the following line into your init.ora file:

unlimited_rollback_segments = true

Oracle says that unlimited extents on the rollback segments are bad but they will let you get away with it.
In article <3651d508.0_at_news.waldonet.net.mt>, "Herbert Zarb" <herbert.zarb_at_bov.com> wrote:
> We have just upgraded from Oracle 7.3.2 to 7.3.4 - however, when we tried to
> startup the database using 7.3.4 we received the following error message
> when the system was trying to open the database:
>
> ORA-01682: rollback segment (1) has unlimited extents
>
> We've looked for this message in all our Oracle documentation but to no
> avail. Does anyone have an idea what this message actually means and whether
> there is any possible (easy) solution?
>
> Thanks,
> Herbert Zarb
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 19 1998 - 17:13:49 CST