ORA-01555 caused by SQL statement below

[Former Member]

Dear all,

How can I treat this error ?

ORA-01555 caused by SQL statement below (SQL ID: 9kh4f608ty7un, Query Duration=88767 sec, SCN: 0x0000.db7b3cef): : Category 1

Any ideas ? I did not touch the DB, so I am not sure why it came.

Thanks in advance,

Daniel.

[former_member182034 · Accepted solution]

HI ,

You have to tune the parameter undo_retention.

for this please have a look Note 185822 - ora-1555 - cause and action

Regards,

[Former Member · Accepted solution]

Danke majamil !!!

Cheers!

[former_member182034 · Accepted solution]

hi Daniel,

You have to mentioned step by step solution (SQL statement) which you perform to resolve this issue.I am saying this for those sdn new users who have no S-user or access of SAP note.

Thanks and Regards,

majamil

Danke???

[Former Member · Accepted solution]

Hi Majamil

Danke = thanks in our original SAP language ( deutsch )

Cheers!

[former_member204080]

Hi,

Please go through notes detailed explanation is given

Note 60233 - Oracle rollback segments, more information.

Note 185822 - ora-1555 - cause and action