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@xxxxxxxxxxx (530) 754-6208 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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