RE: packages becoming invalid at random
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Sep 2009 12:24:06 -0400
If you perform DDL against an object then other objects/code dependent
on that object potentially go invalid. With 11g Oracle has improved the
level of granularity for dependency checking but with 10g and below it
is pretty much at the object level. If you alter a table to add,
modify, or remove a column then triggers on the table, views that
reference the table, and stored code: packages, procedures, and
functions that reference the table become invalid.
See the DBA_DEPENDENCIES view and the related documentation
-- Mark D Powell --
HP Enterprise Services
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lyall Barbour
Sent: Monday, September 28, 2009 10:57 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: packages becoming invalid at random
so, we are doing a large Banner (SunGard's front-end application
like Oracle Apps, but specific toward higher education) upgrade. We've
got it done on Development Oracle 10.2.0.4 and Test databases. We've
seen weird things going on with the packages in Test going invalid, with
what seems like at random.
Can anyone do a brief list of why packages, procedures, etc will
go invalid? like dropping synonyms, or altering tables? or point me to
a doc on that kind of thing?
And then, since this is happening with what seems like at
random, if anyone has any info about how to turn on auditing for ALTER
PACKAGE or DROP TABLE, etc... we have auditing on and it shows when
users are altered, but i don't know much more about auditing.
Thanks everyone,
Lyall
--
An Excellent Credit Score is 750
See Yours in Just 2 Easy Steps!
<http://ad.doubleclick.net/clk;216722518;39159097;q?http://www.freecredi
treport.com/pm/default.aspx?pagetypeid=homepage62&sc=669615&bcd=FOOTER5>
Other related posts:
