RE: Views and triggers invalidated after creating and/or dropping

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Sat, 18 Nov 2000 13:40:42 EST
Message-Id: <10684.122446@fatcity.com>

Alex,
With highly intregted databases like Oracle Financials there are lot of dpendencies exist between objects and even if you drop indexes for AR/AP tables for purpose of reorg you will find lot of views will become invalid. To check this aspect Enterprise Manager is a good tool to check for dependencies.
Regards
Rafiq

From: Alex Hillman <alex_hillman_at_physia.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: Views and triggers invalidated after creating and/or dropping Date: Fri, 17 Nov 2000 13:10:31 -0800

What dependency has view on indexes?

Alex Hillman

-----Original Message-----

Sent: Friday, November 17, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L dropping ind

It is normal behaviour due to dependencies and it is applicable to all oracle versions including 7.3.4.
Just recompile those invalids on fly.
Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Fri, 17 Nov 2000 09:55:23 -0800

Oracle 8.1.6.2, Sun Solaris 7.

Anybody have any idea why dropping indexes can cause invalidation of views?

Alex Hillman

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com.

--

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

Author: Mohammad Rafiq

INET: rafiq9857_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).

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Sat Nov 18 2000 - 12:40:42 CST