Петров Андрей,

Используйте хинт DRIVING_SITE

Oracle® Database
SQL Language Reference
12c Release 2 (12.2)
E49448-12The DRIVING_SITE hint instructs the optimizer to execute the query at a different site
than that selected by the database. This hint is useful if you are using distributed
query optimization.

For example:


If this query is executed without the hint, then rows from departments are sent to
the local site, and the join is executed there. With the hint, the rows from employees
are sent to the remote site, and the query is executed there and the result set is
returned to the local site.