Re: Prepare phase failed ORA-00904: "TABTYPE": invalid identifier

Posted by ErmanArslansOracleBlog on Aug 28, 2023; 1:54pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Prepare-phase-failed-ORA-00904-TABTYPE-invalid-identifier-tp12029p12036.html

TAB is owned by SYS.
You need to concentrate on that.
You issue is related with the access... A synonym may be missing.

When you use "desc tab" command on TEST, you see a different "tab", but on PROD you see the correct "tab".. So probably grants and synonyms are missing on the problematic TEST env.

You already mentioned that you recreated grants and synonyms from adadmin.
But, the issue still seems highly correlated with the synonym issue. check the synonyms using dba_synonyms, compare it with PROD...

* an extra synonym (a custom one) can also create this issue.. You run "desc tab" on TEST, as you see .. And you got a table there. What is it? Do you have an extra synonym mapped to a table name "tab" on TEST?

I think you got this.. Lets see what you can do with that..