Even a simple "COMMENT ON TABLE <tablename> IS ' ' " will suffice to invalidate SQLs against that table and force a re-parse at the next execution.
See http://hemantoracledba.blogspot.com/2008/07/bind-variable-peeking.html At 09:46 PM Wednesday, James Barton wrote:
Forgive me if this is well-documented elsewhere, but I Queried The Fine Google and couldn't find anything: Are there any ways of forcing a query to be replanned, other than gathering stats on one of the queried tables, or flushing the shared pool? Thanks, James
Hemant K Chitale http://hemantoracledba.blogspot.com"A 'No' uttered from the deepest conviction is better than a 'Yes' merely uttered to please, or worse, to avoid trouble." Mohandas Gandhi Quotes : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html