No. You need sysdba priveleges for this.
else you can loop thru

select object_name,object_type
from user_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'TRIGGER', 'PACKAGE',
'PACKAGE BODY', 'VIEW')
and status = 'INVALID'

and execute:
execute immediate 'alter ' || p.object_type || ' ' || p.object_name || '
compile'

in a plsql block



>From: Todd Pepling <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] RE: Invalid Packages
>Date: Fri, 29 Aug 2003 12:19:17 -0400
>
>Can non-DBAs run utlrp.sql?
> -----Original Message-----
> From: Sandeep Dubey [mailto:sandeep.[Email Address Removed] Sent: Friday, August 29, 2003 12:17 PM
> To: LazyDBA.com Discussion
> Subject: RE: Invalid Packages
>
>
> You can run $ORACLE_HOME/rdbms/admin/utlrp.sql to compile all invalid
>packages in the database.
>
> Sandeep
>
> -----Original Message-----
> From: Azelia Paul [mailto:[Email Address Removed] Sent: Friday, August 29, 2003 11:23 AM
> To: LazyDBA.com Discussion
> Subject: Invalid Packages
>
>
> Hey Gang,
>
> All my packages are invalid in Oracle. I got hint from a colleague
>that
>said by exporting the packages and then reimporting them could change the
>status from invalid to valid. Are there any ill affects from running this
>process that you'll know about.
>
>
>
>
>
>----------------------------------------------------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
>The information transmitted is intended only for the person or entity to
>which it is addressed and may contain confidential and/or privileged
>material. If the reader of this message is not the intended recipient,
>you are hereby notified that your access is unauthorized, and any review,
>dissemination, distribution or copying of this message including any
>attachments is strictly prohibited. If you are not the intended
>recipient, please contact the sender and delete the material from any
>computer.
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

Oracle LazyDBA home page