RDBPROD: ORA-02025: All Tables in SQL Statement Must be in Remote Database (Doc ID 67296.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.0 and later
Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

In Oracle RDBMS a database link is defined to go to an Rdb database via OCI Services for Rdb (formerly SQL*Net for Rdb7). An attempt to insert, update, or delete data in an Rdb table based on data in an Oracle RDBMS table results in the following error:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms