Error ORA-00928 when querying view through dblink

[Axr2]

Below is an 8.1.6 bug, but it might be worth trying on yours as well.
1) Try disabling query rewrites.
2) Try setting STAR_TRANSFORMATION_ENABLED = FALSE in your session then run the query.
If it doesn't help, open a TAR.
===============================

BUG 768478 The message "ORA-00928: missing SELECT keyword" can occur when Oracle cost-based optimization attempts to rewrite a query that contains a set operator (e.g. UNION, MINUS, or INTERSECT) with a materialized view. There are three workarounds: 1. Disable query rewrite with an "ALTER {SESSION|SYSTEM} DISABLE QUERY REWRITE" statement. 2. Use a NOREWRITE hint with all SELECT statements referenced by the set operator. 3. Use a REWRITE(mv) hint with all SELECT statements in the set operator to tell the optimizer to explicitly use a materialized view.