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
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