Re: What is "Diana" error in Oracle?

From: <mpir_at_compuserve.com>
Date: Thu, 28 May 1998 20:02:25 GMT
Message-ID: <6kkfsk$59h$1@nnrp1.dejanews.com>

In article <6ki0va$hd8$1_at_nnrp1.dejanews.com>, drpaner_at_intrex.net wrote:
>
> Recently, I was attempting to reference a table (SELECT...) when I was
> prompted by an Oracle (v7.3) message as follows:
>
> "ORA-04028 cannot generate diana for object SCHEMANAME.TABLENAME"
>
> I have checked a number of error manuals and have no idea what this is in
> reference to. I happened only a few times and was never to be seen again.
>
> Has anyone ran into this or have an idea what this is in reference to?
>
> Thank you,
> Daniel
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

Wile I have not seen the particular error, diana is a proc/script set that is usually run during database installation or just after instance creation. Check to see if CATPROC.SQL and/or its cousins were run. The scripts install pl/sql and other objects in the data dictionary.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 15:02:25 CDT