Re: TKPROF/Explain problem

From: Roger Snowden <rsnowden_at_IHateSpam.com>
Date: 1997/03/19
Message-ID: <01bc34ab$9e2c8120$096fc589_at_RSNOWDEN.labinterlink.com>#1/1

I had a similar problem. It seems to happen when a sql statement makes use of a private synonym. The plan user doesn't see the synonym and therefore thinks the underlying table doesn't exist. Maybe this applies in your case.

Roger

> error during parse of EXPLAIN PLAN statement
> ORA-00942: table of view does not exist
>
> I have verified that the plan_table does exist and I am the owner.
Received on Wed Mar 19 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: venkat: "Problem with oracle and web server on SGI"
Previous message: Alexey E. Neckrasow: "Re: Question on porting Designer 2000 repository to another machine"
In reply to: Clay Isaacs: "TKPROF/Explain problem"
In reply to Clay Isaacs: "TKPROF/Explain problem"
Next in thread: Andrey A. Efimov: "Re: F4.0: Problem using libraries..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message