Message-Id: <10575.113364@fatcity.com> From: "Jamadagni, Rajendra" Date: Mon, 31 Jul 2000 10:28:58 -0400 Subject: RE: Deploying Database Packages 1. use REMOTE_DEPENDENCY_MODE=SIGNATURE in your initsid.ora file 2. SEPERATE package spec and package body in different files. 3. Compile Package specification only when underlying TABLE structure or package interface changes. 4. 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.