Failure to extend rollback segment
From: Billy Chambless <billy_at_mars.NoSubdomain.NoDomain>
Date: 1995/05/30
Message-ID: <3qg2cc$5bs_at_NNTP.MsState.Edu>#1/1
Date: 1995/05/30
Message-ID: <3qg2cc$5bs_at_NNTP.MsState.Edu>#1/1
In importing some fairly huge tables, I'm getting the following messages:
/* begin Oracle messages */
/* end Oracle message */
. . importing table "WDB_600M_CST"
IMP-00003: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment (id = 3)
ORA-01650: unable to extend rollback segment R02 by 150 in tablespace
RBS
IMP-00028: partial import of previous table rolled back: 2126 rows
rolled back
I'm having a hrd time grasping the section on managing rollback segments in the Administrator's Guide; what exactly do I need to do here?
Another error I'm getting is:
ORA-1652: Unable to extend temp segment by 520 in <tablespacename>
Neither 1652 nor 1562 shows up in the error codes book.
Help!
--Received on Tue May 30 1995 - 00:00:00 CEST
* Billy Chambless
* billy_at_cast.msstate.edu Voice: 601.688.7608 FAX: 601.688.7100
* Mississippi State University Center for Air-Sea Technology