We have 3 Oracle 19c sites. To keep it simple, call them SiteA, SiteB, and SiteC. The instance at SiteB has a DB Link to SiteA; and the instance at SiteC has a DBLink to SiteB. However, there is no dblink from SiteC to SiteA. Is there a way to access the instance at SiteA from the instance at SiteC directly, without creating another DB Link ?
I tried using 2 @’s to reference the 2 DB Links, but it is obviously not the correct syntax:
eg. table@site_a@site_b
New contributor
Bistic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.