Thursday 29 August 2013

PLS-00201: identifier 'UTL_RECOMP.RECOMP_PARALLEL' must be declared

When trying to compile invalid objects getting below error?


SQL> execute utl_recomp.recomp_parallel(4);
BEGIN utl_recomp.recomp_parallel(4); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_PARALLEL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Cause : you are compling the invalid object using different schema
utlrp.sql has to be run with "sysdba"


Solution:Please login with sysdba and try it again.

No comments:

Post a Comment