Oracle does not recognize UTL_RECOMP.RECOMP_SERIAL at schema level.

EXEC UTL_RECOMP.recomp_serial('SCOTT');

Error starting at line 5 in command:
EXEC UTL_RECOMP.recomp_serial('SCOTT')
Error report:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:
gram77Asked:
Who is Participating?
 
devindCommented:
Are you connecting as sysdba ?
If not then connect using sys as sysdba and run EXEC UTL_RECOMP.recomp_serial('SCOTT'); from Sql*Plus.
0
 
gram77Author Commented:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
0
 
nsonbatyCommented:
from this link
http://www.oracle-base.com/articles/misc/RecompilingInvalidSchemaObjects.php
please conform that the following been checked, specially 2 and 3

1-Parallel execution is perfomed using the job queue. All existing jobs are marked as disabled until the operation is complete.
2-The package must be run from SQL*Plus as the SYS user, or another user with SYSDBA.
3-The package expects the STANDARD, DBMS_STANDARD, DBMS_JOB and DBMS_RANDOM to be present and valid.
4-Runnig DDL operations at the same time as this package may result in deadlocks
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
gram77Author Commented:
no i connect using my id not as sys
0
 
devindCommented:
Connect as Sys user and then try EXEC UTL_RECOMP.recomp_serial('SCOTT');

sqlplus sys/password as sysdba
EXEC UTL_RECOMP.recomp_serial('SCOTT');
0
 
devindCommented:
or grant sysdba role to your user  and then use your user.
grant sysdba to username;
0
 
nsonbatyCommented:
any command on schema level should be by using sysdba and usually SA
0
 
gram77Author Commented:
excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.