K kmm_micha Member May 30, 2006 #1 Can you show me the code you use to compile invalid objects? Thanks and waiting answer!
C CTzen Member³ May 30, 2006 #1 Tools -> Compile Invalid Objects -> F8 or you can run ORACLE_HOME/rdbms/admin/utlrp.sql to recompile ALL invalid objects in database.
Tools -> Compile Invalid Objects -> F8 or you can run ORACLE_HOME/rdbms/admin/utlrp.sql to recompile ALL invalid objects in database.
K kmm_micha Member Jun 1, 2006 #1 Wow, it works perfeclty.... on 10G version, but did not word on 9i. What code or file works on 9i?
C CTzen Member³ Jun 2, 2006 #1 I'm not sure which "wow" worked for you, but they both should work on 9i as well. Code: [oracle@server][lib9i:9.2.0][~] [09:54:27]$ ls -l ./product/9.2.0/rdbms/admin/utlrp.sql -rw-r--r-- 1 oracle dba 3842 Mar 9 2002 ./product/9.2.0/rdbms/admin/utlrp.sql
I'm not sure which "wow" worked for you, but they both should work on 9i as well. Code: [oracle@server][lib9i:9.2.0][~] [09:54:27]$ ls -l ./product/9.2.0/rdbms/admin/utlrp.sql -rw-r--r-- 1 oracle dba 3842 Mar 9 2002 ./product/9.2.0/rdbms/admin/utlrp.sql
