RE: To compile all the views and procedures

as sys...  

SQL> @?/rdbms/admin/utlrp  

I think that's what you are after?  

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anant (DBA) Sent: Thursday, September 06, 2007 3:56 PM To: oracle-l
Subject: To compile all the views and procedures

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

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