We encountered ora-02025 when trying to join 2 tables (one table in Oracle and one table in Postgresql) via database link. The message is clear, but we would like to know if this applies only to certain remote database systems?
No problems between MS SQL Server and Oracle.
The Gateway doc says: ORA-02025: All tables in the SQL statement must be at the remote database.
Is there a workaround for this issue?