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