Hi Chaps,

I have created a database link to access one database from another.

Oracle does not give me any error when creating the database link and the entry also exists in the table

ALL_DBA_LINKS

however when I try to insert data from one table to another using an

INSERT INTO table
( columns)
SELECT column values FROM table@database_link_name

it gives me an error saying

ERROR at line 79:
ORA-12154: TNS:could not resolve service name

and the error points to the database link name in SQL.

I cannot understand what TNS names has to do with this... Why is this going to TNS names? The oracle doc does not tell me to create a TNS names entry when I create a DB link? What could be the problem here?