Unable to delete data from table "ACCTIT" during import

[Former Member]

Hi,

I am doing export/import to my new Test server(Windows 2000) from my Production System(SAPR/3 4.6C Oracle 8.1.7.3.0).

I have succesfully installed Central instance.Now at the last stage(i think) I am getting the error(DBR3LOADEXEC_NT_ORA Phase).

First it was getting an error "ORA-01631: max # extents (300) reached in table SAPR3.ACCTIT".

Then I have extended the max extents to UNLIMITED for this table from SQL level.

Now I am getting the following error.

I have tried every possible actoion that I could do...Extending the PSAPROLL maxtents to UNLIMITED.

Extending every rollback segs to UNLIMITED.

Yet also the result is same.

Plz plz plz help me out (I am in 94% of completion)

#Trying to create primary key "ACCTHD~0"

(IMP) PRKEY: "ACCTHD~0"

#Trying to create index "ACCTHD~1"

(IMP) INDEX: "ACCTHD~1"

(IMP) TABLE: "ACCTIT"

TAB: ACCTIT

FIL: J:\expdir\DATA\SAPAPPL1.001 #20071205152057

DbSl Trace: ORA-1631 occured; SQL statement is ==>

(OLD) ERROR: DbSlExeModify: rc = 99, table "ACCTIT", current block: 8155

(SQL error 1631)

error message returned by DbSl:

ORA-01631: max # extents (300) reached in table SAPR3.ACCTIT

#STOP: 20071205153043

#START OF LOG: 20071205153400

1. R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#35 $ SAP

2. R3load -i SAPAPPL1.cmd -p SAPAPPL1.log -r

1. start of syntax check ###

1. end of syntax check ###

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

DbSl Trace: ORA-1562 occured; SQL statement is ==>

(RIM) ERROR: unable to delete data from table "ACCTIT"

DbSl rc = 99

#STOP: 20071205160912

#START OF LOG: 20071205162720

1. R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#35 $ SAP

2. R3load -i SAPAPPL1.cmd -p SAPAPPL1.log -r

1. start of syntax check ###

1. end of syntax check ###

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

DbSl Trace: ORA-1562 occured; SQL statement is ==>

(RIM) ERROR: unable to delete data from table "ACCTIT"

DbSl rc = 99

#STOP: 20071205170221

#START OF LOG: 20071205174148

1. R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#35 $ SAP

2. R3load -i SAPAPPL1.cmd -p SAPAPPL1.log -r

1. start of syntax check ###

1. end of syntax check ###

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

DbSl Trace: ORA-1562 occured; SQL statement is ==>

(RIM) ERROR: unable to delete data from table "ACCTIT"

DbSl rc = 99

#STOP: 20071205181643

#START OF LOG: 20071205184958

1. R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#35 $ SAP

2. R3load -i SAPAPPL1.cmd -p SAPAPPL1.log -r

1. start of syntax check ###

1. end of syntax check ###

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

DbSl Trace: ORA-1562 occured; SQL statement is ==>

(RIM) ERROR: unable to delete data from table "ACCTIT"

DbSl rc = 99

#STOP: 20071205192440

#START OF LOG: 20071205194712

1. R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#35 $ SAP

2. R3load -i SAPAPPL1.cmd -p SAPAPPL1.log -r

1. start of syntax check ###

1. end of syntax check ###

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

DbSl Trace: ORA-1562 occured; SQL statement is ==>

(RIM) ERROR: unable to delete data from table "ACCTIT"

DbSl rc = 99

#STOP: 20071205202128

#START OF LOG: 20071205204041

1. R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#35 $ SAP

2. R3load -i SAPAPPL1.cmd -p SAPAPPL1.log -r

1. start of syntax check ###

1. end of syntax check ###

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

DbSl Trace: ORA-1562 occured; SQL statement is ==>

(RIM) ERROR: unable to delete data from table "ACCTIT"

DbSl rc = 99

#STOP: 20071205213710

[Former Member]

Hi Mofizur,

This error generally occurs when rollback segment is small.

Create a new tablespace (eg. PSAPROLLBIG) for big rollback segment and activate it and deactivate other rollback segment and restart import. Once import finish you can remove the rollback segment and delete the tablespace.

- Pinkle

[Former Member]

Hi,

The problem is solved.

As the Installation got stopped.

SO I connected to Oracle by

>Conn "/as sysdba".

>Truncate Table <Table Name>.

>Restated teh Installation.

It went smooth.

Thanks a lot for all ur help.

Regards,

Mofizur,

[stefan_koehler]

Hello Mofizur,

which rollback segment is used by the delete statement?

Is there any error in the alert.log ?

And please post the relevant row of DBA_ROLLBACK_SEGS for the rollback segment.

Regards

Stefan