Oracle Database Discussions

Hi,

I am on Oracle 10g R2. I have two schema A and B and I have one table 'T' in A.

I have granted select on T to B from A.

I made sure there are no public synonyms and there are no synonyms for this object exist in B ( initially). There was a synonym though in B for this object and there was also a public synonym. I dropped these synonyms and ensured there are no other synonyms. Also please note there was a view in B with the same name and dropped that view as well. I wanted to have just a synonym in B and no views or whatsoever. I kind of cleared all views synonyms in B related to table T.

I ensure I am able to do select * form A.T from B and I get the desired results.

now I create a synonym as create synonym B.T for A.T

when I do select * from T or select * from B.T (logged in as B). I get the following error:
ORA-04045: errors during recompilation/revalidation of PUBLIC_DW.DIM_PROD_PRIC
ORA-00980: synonym translation is no longer valid

I can still do select * from A.T and get the results and so obviously there is no problem in the table T and there is no problem accessing it from B. Can somebody please tell me why I am getting this error?

thanks in advance