-
describe on remote synonym fails
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|