We already tried "alter package x compile body" but no luck. Still it hangs. ----- Original Message ----- From: "Powell, Mark D" <mark.powell@xxxxxxx> Date: Tuesday, August 31, 2004 4:12 pm Subject: RE: package compilation hangs > Jay, to compile a package Oracle takes an exclusive lock on the > package.Oracle cannot get the exclusive lock if the package is in > use. You should > generally not make changes to tables referenced in stored code > that itself > is referenced by other stored code except during periods of very > low usage > or maintenance windows. > > If you must make the change during busy periods you should try to > stop or > get the users out of the affected applications at the time of the > change.Then when you go to recompile invalided packages only > recompile the body if > the specification was not changed since recompiling the > specification can > cause cascading invalidations. > > If you want long enough the re-compile may well work, but you > might try > canceling it and issuing just a recompile on the body if you made this > mistake. > > alter package x compile [spec and body] verse alter package x > compile body > [to just do the body and limit cascading if the spec was not > changed] > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------