Hi guys,

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;
ERROR:
ORA-04043: object OVDIM.VW_HADAS_KABLANIM does not exist

SQL> select count (*) from VW_HADAS_KABLANIM;

COUNT(*)
----------
148


DESCRIBE fails and regular select works.

Does anyone face with this kind of problem?

Both databases are 8.1.7.3 on HP-UX.

Regards,

Nir