Oracle Spatial, query via database link

Question

Oracle

I'm trying to run a query like this:

select * from [email protected]_link c where sdo_relate(
      c.geometry,
      sdo_geometry(
         blabla
      ),
      'mask=anyinteract'
   ) = 'TRUE';

The database complains about the lack of a spatial index in the tbl table. If you make the same request by connecting directly, without a database link, then everything works.

Google gives out one topic on the forum, where in 2004 they wrote that this would not work. Tell me, what has changed by our time? Or if this is not possible, then how can I perform a similar query to another database?

Answer 1

Brainstorm: Make a function? Make VIEW? Everything is at the database level…
PS: Maybe the “spatial index” is really missing?