Re: HELP !!

From: Kevin Loney <Kevin.Loney_at_astramerck.com>
Date: Tue, 17 Nov 1998 16:48:56 -0500
Message-ID: <gbm42.1122$y33.2541477@newshog.newsread.com>

There's an init.ora parameter called unlimited_rollback_segments set to either TRUE or FALSE. It sounds like you have it set to FALSE (which is the default) while one of your rollback segments is set to have unlimited extents. To open the database, change the setting to TRUE, open the DB, alter the rollback segment to have a limited number of extents, change the setting back to FALSE, and blink the database again.

hth.
Kevin Loney.
http://www.kevinloney.com

Herbert Zarb wrote in message <3651d508.0_at_news.waldonet.net.mt>...
>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
>
Received on Tue Nov 17 1998 - 15:48:56 CST