cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot delete request from ODS

Former Member
0 Kudos

Hi All,

I'm trying to delete a request (full load) from an ODS. But it ends up in a Runtime error. The load performed normal before.

Runtime errors: DBIF_RSQL_SQL_ERROR

Exception: CX_SY_OPEN_SQL_DB

1. ORACLE storage space request failed. (ORACLE error 1547)

2. Maximum number of extents reached for rollback segment. (ORACLE error 1556)

Anyone with an idea about this?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This is oracle system error. Your oracle DBA has to release rhe extents for you to carry out the operation.

Ravi Thothadri

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Beumer,

do you have Informix? Look at this note - 36968. You certainly need Basis team intervention in this matter. usually they know better on these issues.

Viren

Former Member
0 Kudos

No, Oracle 8i

Former Member
0 Kudos

Hi,

Check for the storage space in the system I think your table space is less then required that why it is not able to roll back.

If then contact the basis for more space,

hope it helps

thanks

Former Member
0 Kudos

Strange thing is... table space looks to be ok...