Database Link - TNS names error
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?
A farmer learns more from a bad harvest than a good one