Can I link database links in Oracle?

Question

I have 3 databases. 1 link to 2, 2 links to 3. I would like to query tables in 3, starting with 1. I tried third_db_tab @ 3 @ 2 and it did not work. Think about whether this is possible, and if so, what syntax is there.

Answer 1

I think you can do this by creating synonyms. In database 2, create a synonym:

CREATE SYNONYM third_db_tab for third_db_tab@3;

then in database 1, create a second synonym:

CREATE SYNONYM third_db_tab for third_db_tab@2;

This has not been verified (I don't have three databases right now), but I think Oracle is smart enough to unravel synonyms.