E-ES: Full Index Build fails with ORA-01555: on DELETE FROM PSAPMSGPUBDATA WHERE EXISTS (Doc ID 2414418.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

On : 8.55 version, Search Framework

Full Index No Success.

The process went for more than 2.5 hours and gave below error.

SQL error. Function: SQLExec Error Position: 0 Return: 1555 - ORA-01555: snapshot too old: rollback segment number 5 with name "_<SYSNAME>$" too small Statement: DELETE FROM PSAPMSGPUBDATA WHERE EXISTS (SELECT '*' FROM PSAPMSGARCHTMP2 B, PSAPMSGSUB CON C WHERE (PSAPMSGPUBDATA.IBTRANSACTIONID = C.CANONICALTRSFRMID OR PSAPMSGPUBDATA.IBTRANSACTIONID = C.IBTRANSACTIONID) AND B.IBTRANSACTIONID = C.IBPUBTRANSACTID) Original Statement: DELETE FROM PSAPMSGPUBDATA WHERE EXISTS (SELECT '*' FROM PSAPMSGARCHTMP2 B, P SAPMSGSUBCON C WHERE (PSAPMSGPUBDATA.IBTRANSACTIONID = C.CANONICALTRSFRMID OR PSAPMSGPUBDATA.IBTRANS

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.