Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deploying Database Packages

RE: Deploying Database Packages

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Mon, 31 Jul 2000 10:28:58 -0400
Message-Id: <10575.113364@fatcity.com>

  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. Received on Mon Jul 31 2000 - 09:28:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US