Hi: I have remedy on one server and oracle database on another server. When I try to access a table accessible via dblink to create a view form, I get the following error

Requested database table not found. Please check the spelling (table name is case-sensitive) : alarm_translat...@mds_arsp02_dblink (ARERR 481).

I can access the table from the sql prompt on the oracle database under aradmin user.
bash-2.05$ sqlplus ARADMIN/p...@rmdsp02
.
.
SQL> select count(*) from alarm_translat...@mds_arsp02_dblink;

 COUNT(*)
----------
     6321


Any suggestions.
Thanks
Ravi

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to