Re: TKPROF/Explain problem
Date: 1997/03/26
Message-ID: <01bc39ef$b2126c10$821c41c2_at_tubarao>#1/1
[Quoted] In a couple of days we will have a demo of our TunaSQL product available for download at www.cardume.com. It can help this problem.
Fernando (morgan_at_cardume.com)
CardumeSoftware
www.cardume.com
Roger Snowden <rsnowden_at_IHateSpam.com> wrote in article
<01bc34ab$9e2c8120$096fc589_at_RSNOWDEN.labinterlink.com>...
> 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 26 1997 - 00:00:00 CET