"ORA-01729: Database Link Name Expected" Error in a Data Integration Job

Owned by Former user (Deleted)
Last updated: Mar 15, 2018 by Stephanie Fourrier
1 min read

Problem

When executing a mapping loading data across 2 different oracle schemas within the same instance, the following error appears

SQL Exception Error : ORA-01729: database link name expected

Solution

When you have a source and target table on Oracle, the Load template automatically defaults to LOAD Oracle to Oracle (DBLink). This template expects a database link to be defined on Oracle and is relevant for moving data across different instances.
Change the Load template to LOAD Rdbms to Oracle.This template moves data within an instance and does not require any DB Link.