Xref: alice comp.databases.oracle.server:56421 Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!diablo.theplanet.net!news.theplanet.net!newspost.theplanet.net!not-for-mail From: Connor McDonald Newsgroups: comp.databases.oracle.server Subject: Re: Shared SQL Area question Date: Wed, 07 Jul 1999 22:51:11 +0800 Organization: Customer of Planet Online Lines: 22 Message-ID: <3783695F.74F4@yahoo.com> References: <7lvvvs$hml$1@nnrp1.deja.com> Reply-To: connor_mcdonald@yahoo.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news5.svr.pol.co.uk 931384050 14870 62.136.196.161 (7 Jul 1999 21:47:30 GMT) NNTP-Posting-Date: 7 Jul 1999 21:47:30 GMT X-Complaints-To: abuse@theplanet.net X-Mailer: Mozilla 3.01 (Win95; I) To: canglin@anglingroup.com canglin@anglingroup.com wrote: > > If an object referenced in SQL statement in the shared pool is modified, > the statement is flagged as invalid. If a new object is created > (index), does this invalidate the statement in the shared pool? If yes, > how does Oracle know the index has been created. > > Thanks > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. Check out user_dependencies -- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald@yahoo.com "Some days you're the pigeon, and some days you're the statue."