Re: To compile all the views and procedures

Thank you very much for all your valuable help :-).

Reg,
Ann

On 9/7/07, Don Seiler <don_at_seiler.us> 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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l