What if you too many invalid objects how do get the errors messages for these objects
run the query against dba_errors and the text column holds the error message.
run the utlrp.sql to compile all the objects
SQL> @?/rdbms/admin/utlrp.sql
see it made any difference if not then view the error messages from above and start troubleshooting..
run the query against dba_errors and the text column holds the error message.
run the utlrp.sql to compile all the objects
SQL> @?/rdbms/admin/utlrp.sql
see it made any difference if not then view the error messages from above and start troubleshooting..
No comments:
Post a Comment