Re: Oracle 10G explain plan ora-4045

"Maria" <evoradba_at_yahoo.ca> wrote in message news:351fd9d6.0501271629.103d5eb_at_posting.google.com...
> While using the explain plan like oracle 8i and 9i now moved to 10g
> and then this error message pops up
>
> ora-4045: errors during recompilation/revalidation of PUBLIC.DEPTH,
> and
> ora-980 synonym translation is no longer valid
> I have run the catalogs of the db for any invalid object and still get
> the same error! does any one know why? is there a way getting the
> explain plan using oracle 10G? 10.1.0.3 on sun 5.8
>
> Regards
> Maria

Are you trying to explain a query that contains an object called DEPTH? it looks like that rather than explain plan itself.

That said I see you refer to doing explain plan in the same way as in 8i. It changed in 9i - you should now really be using

select * from table(DBMS_XPLAN.DISPLAY);

If you look up DBMS_XPLAN in the docs you'll see that you can get more and better information, but the above should get you started.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com