Oracle-L: Significance of DBA_OBJECTS dates and invalid objects

From: Vasu Ramasamy <vasu.ramasamy_at_sri.com>
Date: Fri, 19 Jul 2002 08:33:24 -0800
Message-ID: <F001.0049CB28.20020719083324@fatcity.com>

Hello Gurus,

I am trying to understand the role played by the following dates in DBA_OBJECTS.

      CREATED
      LAST_DDL_TIME
      TIMESTAMP

I was playing with different actions/commands to see how they affect these dates. These are my observations.

Dropping and recreating an object changes all the 3 dates
'Create or replace' ( of a procedure) changes the last two dates.
Grant or revoke changes only the LAST_DDL_TIME.

Are there any other commands/actions that changes these dates?

I am trying to identify the problem that causes the objects to become invalid.
Most of our procedures and functions (about 60% of the procedures), almost twice a week become invalid. I am trying to find what makes these objects to become invalid. Any of the above 3 items can make the objects invalid. We don't do much of Item 1 and 3. Item 2, changing the procedure, happens all the time. I do not see replacing the procedure will make so many procedures to become invalid. There only 2 developers working on their own set of procedures. I checked the dependencies. Other procedures which are becoming invalid do not depend on these procedures.

Any help towards resolving this issue also will be appreciated.

Thanks

Vasu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vasu Ramasamy
INET: vasu.ramasamy_at_sri.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jul 19 2002 - 11:33:24 CDT