Hello all,

I got a problem when loading data from our production database into our data warehouse using a procedure. When we were executing this procedure, we got the following errors:

ERROR at line 1:
ORA-02055:
distributed update operation failed; rollback required
ORA-01653:
unable to extend table xxx by 1024 in tablespace 'tblspc'
ORA-02063: preceding line from WRHS
ORA-06512: at 'procname', line 599
ORA-06512: at line 1

Checked ORA-0255, the action is: Roll back to a savepoint or rollback the entire transaction and resubmit the rolled-back statements. We rolled back the entire transaction. Also,there are two datafiles on that tablespace, one of these two got autoExtend enabled. I enabled the Autoextend on the other datafile and tried to execute the procedure, again, we got:

ERROR at line 1:
ORA-02055:
distributed update operation failed; rollback required
ORA-01653:
unable to extend table xxx by 1024 in tablespace 'tblspc'
ORA-09217: sfsfs: failed to resize file
OSD-02081:
Message 2081 not found; product=RDBMS73; facility=SOSD
(OS 1)
ORA-09217: sfsfs: failed to resize file
OSD-02081:
Message 2081 not found; product=RDBMS73; facility=SOSD
(OS 1)
ORA-02063: preceding 7 lines from WRHS
ORA-06512: at 'procname', line 599
ORA-06512: at line 1

We use Oracle 7.3.4 on Novell 5.0 and I checked the operating system-specific Oracle documentation, there is no OSD-0281. What should I do to fix this problem. Should I resize the rollback segment? Any advice would be appreciated. Thanks in advance.

Li





[Edited by cui_li on 11-15-2000 at 07:56 PM]