RE: Object Invalid

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Wed, 28 Nov 2001 03:51:58 -0800
Message-ID: <F001.003CEB86.20011128034156@fatcity.com>

Seema, if these invalid objects are things like triggers or procedures that your system will call at some point, then these will fail. You can find scripts that can revalidate these objects on many of the Oracle sites or if you want I can send you one.

Dave

-----Original Message-----
Sent: Tuesday, November 27, 2001 9:15 PM To: Multiple recipients of list ORACLE-L

Hi
What could be impact if objects are having status INVALID? Thanks
Seema

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--

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

Author: Seema Singh
INET: oracledbam_at_hotmail.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).
--

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

Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com

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