Re: To compile all the views and procedures
- From: "Anant (DBA)" <shastry17@xxxxxxxxx>
- To: "Don Seiler" <don@xxxxxxxxx>
- Date: Fri, 7 Sep 2007 05:15:18 +0530
Thank you very much for all your valuable help :-).
Reg,
Ann
On 9/7/07, Don Seiler <don@xxxxxxxxx> wrote:
>
> you can use DBMS_UTILITY.COMPILE_SCHEMA() to compile all or just
> invalid PL/SQL in a given schema.
>
> Don.
>
> 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
> oracle: http://ora.seiler.us
> ultimate: http://www.mufc.us
>
Other related posts:
