Database Link Usage With Spatial Objects (No Spatial Operators) = ORA-22804
Last updated on JULY 17, 2017
Applies to:
Oracle Spatial and Graph - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]Information in this document applies to any platform.
***Checked for relevance on 30-Jan-2014***
Symptoms
If the source instance is 10.2.0 and the target instance is 11.1.0, the following fails in SQL*Plus:
SQL> select *
2 from test@testlink;
ID
----------
SHAPE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
----------------------------------------------------------------------------------------------------
1
SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(1, 1, 5, 7))
SQL> insert into test
2 select *
3 from test@testlink;
insert into test
*
ERROR at line 1:
ORA-22804: remote operations not permitted on object tables or user-defined type columns
2 from test@testlink;
ID
----------
SHAPE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
----------------------------------------------------------------------------------------------------
1
SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(1, 1, 5, 7))
SQL> insert into test
2 select *
3 from test@testlink;
insert into test
*
ERROR at line 1:
ORA-22804: remote operations not permitted on object tables or user-defined type columns
This works if the source and target are both 10.2.0, or if the source is 11.1.0 and the target is 10.2.0.
(Notice: No Spatial operators/indexes are being used here.)
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms