Oracle DB Error ORA-01729 database link name expected

The following is the cause of this error:

A database link name does not follow the at-sign (@) in a reference to a table in a remote database.

Action you can take to resolve this issue: Correct the reference and retry the operation. The correct syntax for denoting a table in a remote database follows:

username.table_name@ database_name
Spaces before and after the at-sign (@) are optional.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related