ORACLE error 1562 encountered

[Johnson Huang]

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.

[Markus Korn]

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

[Jens Loebling]

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