Database Link Usage With Spatial Objects (No Spatial Operators) = ORA-22804
(Doc ID 1070567.1)
Last updated on DECEMBER 26, 2019
Applies to:
Oracle Spatial and Graph - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]Oracle Spatial and Graph - Version 12.2.0.1 to 12.2.0.1 [Release 12.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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |