Re: ORACLE error 1562 encountered

From: Jens Loebling <jens.loebling_at_o-tel-o.com>
Date: Fri, 25 Jun 1999 10:31:51 +0200
Message-ID: <37733E77.7A3ADB43@o-tel-o.com>

Johnson Huang schrieb:
>
> 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.

Hallo Johnson,
your rollbacksegnents are to small to import your data. Therefore this transaction is rolld back and nothing is imported. You have two ways to solve this problem.

I .) Use COMMIT=Y in the parameter file or command line. II.) IF COMMIT is not possible increase your rollbacksegments

     or the tablespace containing the rollbachsegnent.
     OR change the storage parameter of the rollback segment.

If you are not sure how to use import imp help=Y my help or the following link
http://sellene.zcu.cz/oracle/server/sut73/toc.html

Best Regards
Jens Loebling Received on Fri Jun 25 1999 - 03:31:51 CDT