Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 10G explain plan ora-4045

Oracle 10G explain plan ora-4045

From: Maria <evoradba_at_yahoo.ca>
Date: 27 Jan 2005 16:29:40 -0800
Message-ID: <351fd9d6.0501271629.103d5eb@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
Received on Thu Jan 27 2005 - 18:29:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US