Re: Shared SQL Area question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 Jul 1999 22:51:11 +0800
Message-ID: <3783695F.74F4@yahoo.com>

canglin_at_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_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 07 1999 - 09:51:11 CDT