Re: To compile all the views and procedures

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