Dave Brady (brady@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@fas.harvard.edu         LL1A Science Center
: Phone: (617) 495-1273         1 Oxford Street
: FAX:   (617) 495-1210         Cambridge, MA 02138
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:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ack to Ari Kaplan's Home Page