Hi
I am working on a migration piece where I am having to select across a db link and perform a join on two remote tables which are backend tables of an Oracle GIS system. A where clause drives the join which has a filter criteria as follows
select s.id,b.id,s.name,b.address_line_1
from
schema.table_a@dblink b, schema.table_b@dblink s
WHERE sdo_anyinteract(s.geometry,b.geometry) = 'TRUE';
where geometry column is an SDO_GEOMETRY datatype in the tables.
I am not able to perform a select over this link not am i able to perform an insert into ...select from.
I get the error
SQL Error: ORA-22804: remote operations not permitted on object tables or user-defined type columns
22804. 00000 - "remote operations not permitted on object tables or user-defined type columns"
*Cause: An attempt was made to perform queries or DML operations on
remote object
tables or on remote table columns whose type is one of object,
REF, nested table or VARRAY.
Is there any way around this or am I doing something wrong.
The source database is Oracle 11g R2 and target is Oracle 12c.