Oracle-Powerhouse: use of links / synonyms

[Robert J.M. Edis]

G'day Johnnie

I am using PowerHouse 7.33 (HP-UX 10.20) with an Oracle 7.3.4 RDBMS.  A
number of the programs refer to tables existing in other databases (Oracle
8.0.5) for both read and update wit hno problem at all.

No change was made to the PHD and the tables are referenced as if they are
local.

The 'foreign' database tables are set up as a dblink in the 'host' database
using a privileged account.  The specific tables needed are declared with
synonyms using the appropriate rights.

The ORACLE_SID variable has not been changed.

Are you using SQL*Plus from the same machine as PowerHouse is running on?
Has the TNSNAMES.ORA file been completed correctly?  (E.g. are you using the
'world' option on the instance name?

Regards,
Blue 

-----Original Message-----
From: Johnnie Sheppard
To: powerh-l
Sent: 8/2/00 11:18 AM
Subject: Oracle-Powerhouse:   use of links / synonyms

Has anyone used Oracle external  links &/or synonyms to access a remote
database
via Powerhouse?   Are there any special issues that need to be addressed
before
Powerhouse can use the links &/or synonyms.  Our DBA has added an
external
database link to a local database which can be used in SqlPlus but not
in Powerhouse.
She also added a synonynm, but we apparently still can't access the
remote table
in Powerhouse.  Any ideas would be greatly appreciated.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= =
Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to
majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.