describe on remote synonym fails
We've built on a remote database special user with synonym to a table of the main schema in the remote database.
In the current database,we've built a remote synonym to the synonym of the special remote database's user.
The strane thing is :
SQL> desc VW_HADAS_KABLANIM;
ORA-04043: object OVDIM.VW_HADAS_KABLANIM does not exist
SQL> select count (*) from VW_HADAS_KABLANIM;
DESCRIBE fails and regular select works.
Does anyone face with this kind of problem?
Both databases are 220.127.116.11 on HP-UX.
Click Here to Expand Forum to Full Width