Quick and simple way of recompiling invalid objects:
sqlplus / as sysdba
@$ORACLE_HOME/rdbms/admin/utlrp.sql
Working my way through the dba day to day activities sharing what I learn along the way. Mostly a place to save my own notes for later use and hopefully someone else might find it useful.
Comments
Post a Comment