Re: Failure to extend rollback segment

Billy Chambless (billy_at_mars.NoSubdomain.NoDomain) wrote:

: In importing some fairly huge tables, I'm getting the following
: messages:
 

: /* begin Oracle messages */
: . . 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
: /* end Oracle message */
: 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!

Your problem is probably caused by the default setting of COMMIT=NO in IMP command line. Set it to YES to commit array inserts. Also, your rollback segments and temporary segment might be too small, if reading Oracle documentation doesn't help in understanding the concepts, read Kevin Loney's DBA FAQ (I don't know if it's still around) or buy his excellent Oracle DBA book.

• Janos