You must write the table name in uppercase letters. Kind Regards Conny
-----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Ravi Gesendet: Tuesday, December 16, 2008 4:29 PM An: [email protected] Betreff: Unable to access a dblink table from AR Administrator 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
