Search This Blog

Tuesday, October 21, 2014

ORA-00955: name is already used by an existing object & ORA-06512: at "SYS.UTL_RECOMP", line 662

Issue:

When I ran utlrp.sql to compile the INVALID objects in database, I see it error out due to

DOC>#
DECLARE
*
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 line 4

Cause:

Looks like known bug#9881143 in Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2] where an index is left from a previous failed execution of utl_recomp.

SQL> /

OWNER                          SEGMENT_NAME                                  SEGMENT_TYPE
------------------------------ --------------------------------------------- ------------------
SYS                            UTL_RECOMP_COMP_IDX1                          INDEX


Solution: Drop the index utl_recomp_comp_idx1 left by utl_recomp and then rerun the package.



SQL> drop index UTL_RECOMP_COMP_IDX1;

Index dropped.


Compile script completed successfully:
SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP
----------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2014-10-21 11:14:12

ERRORS DURING RECOMPILATION
---------------------------
                          0

PL/SQL procedure successfully completed.

Reference: Ora-955 Error Running Utl_Recomp.Recomp_Serial (Doc ID 1274504.1)

No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...