Re: Unable to generate diana - Oracle 7

On Tue, 17 Feb 1998 16:18:19 +1000, Mark Gebbie <gebbie.mark.m_at_bhp.com.au> wrote:

>The form of my select (not exact but similar) is this:
>
>select t1.a, (t1.b-t2.c)*t1.d+(t2.e-t1.g) calc_name
>from table_one t1,
> table_two t2,
>where t1.k > t2.j(+)

I hope those are small tables :)

  SELECT STATEMENT
    NESTED LOOPS OUTER

      TABLE ACCESS FULL T1
      TABLE ACCESS FULL T2

Ouch.

>I get the following error:
>
>ORA-04028 Cannot generate diana for object table_one

$ oerr ora 4028
04028, 00000, "cannot generate diana for object %s%s%s%s%s" // *Cause: Cannot generate diana for an object because of lock conflict.
// *Action: Please report this error to your support representative.

This means what you think it does: Better call Oracle support. It could mean any number of things...it probably means you found a bug. Congratulations.

[...]
>What is a diana?

Diana is an internal package. Not really certain what it does, but that's what it is.

/cpk Received on Tue Feb 17 1998 - 00:00:00 CST