Ora-955 error running utl_recomp.recomp_serial (Document ID 1274504.1)

Oracle Server-Enterprise Edition-version 10.2.0.1 to 10.2.0.5 [release 10.2] information in this document applies to any platform.

Symptoms

The utl_recomp package errors out trying to compile a schema.
SQL> exec SYS. utl_recomp.recomp_serial ('Scott ');
Begin sys. utl_recomp.recomp_serial ('Scott '); end; * error at line 1: ORA-00955: Name is already used by an existing object ORA-06512: At "sys. utl_recomp ", line 662 ORA-06512: At" sys. utl_recomp ", line 715 ORA-06512: At line 1

Cause

BUG: 9881143 where an index is left from a previous failed execution of utl_recomp. the following commands can be used to generate a trace file to verify.
Alter session set events '955 trace name errorstack level 3'; Exec SYS. utl_recomp.recomp_serial ('Scott ');
Looking in the trace file will show the Problem Index.
* 12:42:24. 026 ksedmp: internal or fatal error ORA-00955: Name is already used by an existing object current SQL statement for this session: Create index Statement on utl_recomp_compiled (OBJ #) noparallel

Solution

Drop the index utl_recomp_comp_idx1 left by utl_recomp And Then rerun the package.
Sqlplus/As sysdba drop index utl_recomp_comp_idx1; Exec SYS. utl_recomp.recomp_serial ('Scott ');
BUG: 9881143 is fixed in 11g, and there is a one-off patch available for 10.2.0.5 through patch: 12560454.

References

BUG: 9881143-utl_recomp.recomp_serial results in ORA-00955 Note: 12560454.8-bug 12560454-ORA-955 from utl_recomp