IMPORT ERROR

[bgill]

I got the following error while importing table data.

. importing USER1's objects into USER1
. . importing table "ACCOUNTS"
IMP-00058: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment number 5
ORA-01562: failed to extend rollback segment number 5
IMP-00028: partial import of previous table rolled back: 193032 rows rolled back
Import terminated successfully with warnings.


There is currently no data imported into the ACCOUNTS table.

I haven't seen this error before while doing an import. What do I need to do to get arount this error?
Any help gratefully received.

Thanks in advance

[SANJAY_G]

Use COMMIT=Y

HTH
Sanjay

[bgill]

SANJAY,
Thanks for the speedy reply. I dont seem to have a commit option.
This is what I got when I tried again.

[DRserver] /data3/export> imp

Import: Release 8.0.6.0.0 - Production on Wed Sep 4 10:26:10 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Username: user1
Password:

Connected to: Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production

Import file: expdat.dmp > accounts.dmp

Enter insert buffer size (minimum is 4096) 30720>

Export file created by EXPORT:V08.00.06 via conventional path
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no > y

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no > y

. importing USER1's objects into USER1
. . importing table "ACCOUNTS"
IMP-00058: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment number 9
ORA-01562: failed to extend rollback segment number 9
IMP-00028: partial import of previous table rolled back: 152936 rows rolled back
Import terminated successfully with warnings.
[DRserver] /data3/export>

Thanks again

[ggnanaraj]

Do this...

imp user1 file=accounts.dmp log=accounts.log commit=y ignore=y full=y

HTH.


[Edited by ggnanaraj on 09-04-2002 at 05:49 AM]

[bgill]

Thanks guys.
Table successfully imported. Any ideas what could have caused this rollback error? Before the accounts table import I had successfully imported tables of similar size with no problems.

Thanks again for your help

[soniaarora]

As the error suggests, the rollback segments have grown.
Just before u start your import, run the command :
alter rollback segment rbs01 shrink;

It is possible that u have small rollback segments too. So try increasing the rollback segments.