| Oreacle 8i to 9i upgrade-autocompile? [message #74713] |
Mon, 07 February 2005 19:45  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
We are upgrading Oracle 8i database to Oracle 9i.
Will all the objects be compiled automatically when upgrading or manual compilation is needed?
Is there any utility available to do the same...
Pls let me know...
Thanks & Regards
~V~
|
|
|
|
| Re: Oreacle 8i to 9i upgrade-autocompile? [message #74715 is a reply to message #74713] |
Mon, 07 February 2005 23:31  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
It would be best to compile all objects after the upgrade. You can use the utlrp.sql script as documented in the migrations guide:
"21. Run utlrp.sql to recompile any remaining stored PL/SQL and Java code.
SQL> @utlrp.sql
Verify that all expected packages and classes are valid:
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
SQL> SELECT destinct object_name FROM dba_objects WHERE status='INVALID';"
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
