Re: Would you recommend such an application for production use?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 17 Feb 2010 13:47:13 -0800
Message-ID: <bf46381002171347s6a9384bi10a0697984c1c23c_at_mail.gmail.com>

On Wed, Feb 17, 2010 at 1:20 PM, Martin Bach <development_at_the-playground.de>wrote:

>
> - the installation script furthermore creates objects in the sys schema,
> namely create view foo as select * from someX$view
>
> This is disturbing for me
>
>

I also find that disturbing.

If the database is later upgraded so that the data dictionary tables (X$) change,
and the custom views no longer compile, there is no way to remove them, or to recompile them.

Any attempts to recompile them after that happens will always result in an ORA-00600 [16206]. The only way to avoid it is to remember to drop all custom views based on x$ tables prior to the database upgrade, and then recreate them, whereupon they may fail.

It is actually fairly harmless, unless your app needs them, and they no longer work.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 17 2010 - 15:47:13 CST