Re: rollback segs prob. 7.3.2.3 -> 7.3.3.0

I will quote my Oracle documentation, which will solve your proble:

01682, 00000, "rollback segment (%s) has unlimited extents" // *Cause: A rollback segment with unlimited extents was found and init.ora
// parameter unlimited_rollback_segments was set to FALSE // *Action: set unlimited_rollback_segments to TRUE and restart the database.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 125+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Dave Brady (brady_at_fas.harvard.edu) 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