Referring to a table in another database
From: Purushothaman Balakrishnan <pbalakri_at_uceng.uc.edu>
Date: Fri, 4 Mar 1994 17:02:19 GMT
Message-ID: <CM5Gnv.JL_at_uceng.uc.edu>
Date: Fri, 4 Mar 1994 17:02:19 GMT
Message-ID: <CM5Gnv.JL_at_uceng.uc.edu>
Pardon me for this silly question.
I have two instances of two different databases running on one
server. I have a parent table in one database and a child table in another
database. I want to create triggers for maintaining referential integrity
between these two tables.
Every time I try to create a database link and then a synonym for the
table in the link, it assumes the database to be a remote database.
How can I refer to the table in the other database?
Thanks in advance for any suggestions/help.