- use REMOTE_DEPENDENCY_MODE=SIGNATURE in your initsid.ora file
- SEPERATE package spec and package body in different files.
- Compile Package specification only when underlying TABLE structure or
package interface changes.
- When compiling changes to package BODY, don't (I repeat DON'T) compile
package specification unless it is required.
If you follow these, the ORA-4062 incidents should drop down significantly.
HTH
Raj
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Received on Mon Jul 31 2000 - 09:28:58 CDT