Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE error 1562 encountered

Re: ORACLE error 1562 encountered

From: Markus Korn <markus.korn_at_at.siemens.de>
Date: Fri, 25 Jun 1999 08:12:27 +0200
Message-ID: <37731DCB.6F73AB3F@at.siemens.de>

  1. You can use the commit=y option during your import
  2. create "bigger" rollback segments, set the maxextents to unlimited

Johnson Huang wrote:
>
> Dear all,
> When I import data, I enconuntered the below error message.
> Maybe you can help me, thanks
>
> . . importing table "CLC"
> IMP-00003: ORACLE error 1562 encountered
> ORA-01562: failed to extend rollback segment number 2
> ORA-01628: max # extents (121) reached for rollback segment R01
> IMP-00028: partial import of previous table rolled back: 3181024 rows rolled
> bak
> Import terminated successfully with warnings.
Received on Fri Jun 25 1999 - 01:12:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US