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