Re: ora817 sga problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 13 Dec 2005 21:59:10 +0100
Message-ID: <pedup190uik10iagdhkmk9f14md6258v9e@4ax.com>

On Tue, 13 Dec 2005 21:30:13 +0100, Morff <morff1_at_wp.pl> wrote:

>Oracle users from time to time have an error "invalid column name" on
>select from database. That invalid column is usually function based
>column.

Check the status of the function. Likely, for some reason it has gone invalid. If so recompile the function.
The tric to flush the shared pool in such cases is .... ahem... quite strange and disastrous.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 13 2005 - 14:59:10 CST