Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 945
  • Last Modified:

Recompile Stored Procedures in Ora10g

I was wondering if there's a way to recompile stored procedures in SQL*Plus for ora10g?

We are in the process of upgrading from oracle 7.34 to 10g and the old way in SQL*Plus was
EXEC DBMS_UTILITY.Compile_Schema('dbname');

This command no longer works in 10g and we have to go through the Enterprise Manager and compile one by one.

Thank you.
0
goldieretriever
Asked:
goldieretriever
1 Solution
 
jrb1Commented:
One method per oracle is:

1) invalidate all pl/sqls:

dbmsupgnv.sql

2) recompile all pl/sqls:

utlrp.sql

http://www.oracle.com/technology/tech/pl_sql/htdocs/ncomp_faq.html
0
 
anand_2000vCommented:
utlrp.sql will be available in oracle home/rdbms/admin
executing it will recompile all the pl/sql programs
0
 
sujit_kumarCommented:
DBMS_UTILITY should be there. Are you getting ?

ERROR at line 1:
ORA-20000: You have insufficient privileges for an object in this
schema.
ORA-06512: at "SYS.DBMS_UTILITY", line 422
ORA-06512: at line 1

Then check ur previledges.
0
 
goldieretrieverAuthor Commented:
Thanks for the quick responses.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now