Re: To compile all the views and procedures

  • From: "Don Seiler" <don@xxxxxxxxx>
  • To: shastry17@xxxxxxxxx
  • Date: Thu, 6 Sep 2007 18:27:58 -0500

you can use DBMS_UTILITY.COMPILE_SCHEMA() to compile all or just
invalid PL/SQL in a given schema.


On 9/6/07, Anant (DBA) <shastry17@xxxxxxxxx> wrote:
> Hi All,
> I have a requirement like I need to compile all the views and procedures in
> the development database. Can anyone please guide me how to go about with
> this and what are the pre-requisites before we go for compiling. Thanks in
> advance.
> Regards,
> Anant

Don Seiler

Other related posts: