Purge Signon Audit Data Program Fails With ORA-08102 (Doc ID 2081099.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Basic SysAdmin functions, maintenance

The Purge Signon Audit Data Program is failing with the following error:

FND_LOGIN_RESP_FORMS
FND_LOGIN_RESPONSIBILITIES
FND_LOGINS
delete from fnd_logins
  *
ERROR at line 1:
ORA-08102: no se ha encontrado la clave de índice, objeto número 39944, archivo 60, bloque 64539 (2)


We thought this query is interesting:
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id =60
and 64539 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME
----------------- -------------- ------------ ------------------
APPS_TS_ARCHIVE INDEX APPLSYS FND_LOGINS_U1

We rebuilt this index:
SQL> ALTER INDEX APPLSYS.FND_LOGINS_U1 rebuild online compute statistics;

the same the request fails whith ORA-08102

ERROR
-----------------------
ORA-08102

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms