compiled/valid or not compiled... that is the question
From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Wed, 20 Aug 2014 15:43:48 -0300
Message-ID: <CACH2EDLWKuws5bH6KnRp+5Od_KzTgTme7rOmt5XvGdtm9KFCpg_at_mail.gmail.com>
It's fun that in the data dictionary, objects can be listed as "valid" even though their underlying components may have disappeared or db links stopped working properly.
Date: Wed, 20 Aug 2014 15:43:48 -0300
Message-ID: <CACH2EDLWKuws5bH6KnRp+5Od_KzTgTme7rOmt5XvGdtm9KFCpg_at_mail.gmail.com>
It's fun that in the data dictionary, objects can be listed as "valid" even though their underlying components may have disappeared or db links stopped working properly.
The server never double checks, it assumes they ave valid until someone tries to use the object or the database is restarted.
So the information in the data dictionary is not necessarily trustworthy.
- Patrice My profiles: [image: Facebook] <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image: LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image: Twitter] <http://www.twitter.com/PatriceBoivin> <http://www.twitter.com/PatriceBoivin> Signature powered by WiseStamp <http://www.wisestamp.com/email-install>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 20 2014 - 20:43:48 CEST