ORA-13444: cannot perform mergeLayers operation ORACLE 报错 故障修复 远程处理

文档解释

ORA-13444: cannot perform mergeLayers operation

Cause: The two GeoRaster objects whose layers are to be combined together either had different row or column dimension sizes, or their georeferencing information did not match.

Action: Make sure the objects have the same row and column dimension sizes. If neither is georeferenced, their ULTCoordinate values must be the same. Otherwise, they must be both georeferenced and cover the same area in the model space.

ORA-13444：不能执行mergeLayers操作

该错误指示数据分层并不支持mergeLayers操作。mergeLayers操作用于将两个图层组合在一起。

官方解释

在分层图形SQL中，mergeLayers操作是一个操作，用于将多个图层组合在一起，以便构建一个复杂的层次图形。然而，与大多数分层图形SQL操作不同，mergeLayers操作不受Oracle分层图形支持。

常见案例

当尝试使用mergeLayers操作来组合两个图层时，可以出现ORA-13444错误。

正常处理方法及步骤

要解决ORA-13444错误，请改用受分层图形支持的操作，例如addLayers，arcGroups，unGroup 等。以下是一个示例：

SELECT sdo_geom.addLayers(S1.GEOMETRY, S2.GEOMETRY)

FROM SPATIAL_TABLE1 S1, SPATIAL_TABLE2 S2

WHERE S1.ID = S2.ID;