Re: Replacing a view with selects on it

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 17 May 2004 17:00:33 -0600
Message-Id: <6.1.0.6.2.20040517165415.0304f108@pop.centrexcc.com>

At 03:52 PM 5/17/2004, you wrote:

>@Wolfgang - good point; the only access of the view while parsing the
>query - but what happen if the query gets out from library cache and needs
>to be reparsed?
>
>Could there be a situation that it cause some troubles?

I haven't done any tests but I would say that as soon as the view definition is replaced, any query based on that view will use the new definition. I would say that you need not even have to wait for already parsed sql to age out of the shared pool before being reparsed with the new definition if being reused, I'd say all cursors dependent on the view are flagged invalid when the view is rebuilt.

If there are situation where that can cause trouble, such as the read-repeatability that Dan mentioned then you have to be careful with the timing of your view rebuild.

regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 17 2004 - 17:57:41 CDT