Return
-
Title
Does SharePlex support SDO_GEOMETRY in CDC setup - CDC Post stopped due to ORA-00947. -
Description
In SharePlex CDC setup, Post was stopped with ORA-00947: not enough values, and this happened on a table containing SDO_GEOMETRY data type.
-
Cause
Currently SharePlex does not support operations on:
1. Changes made to UDT or VARRAY columns.
2. DBMS_LOB operations that are used to change a portion of a LOB column
(The value stored for that column on the Target will not be the complete LOB column.)
SDO_GEOMETRY is Oracle UDT which also includes varray in its definition, so tables with an SDO_GEOMETRY type is not supported in CDC setup.
-
Resolution
Remove table from replication.
For data already in Post queue, it can be skipped using: SP_OPO_DISABLE_OBJECT_NUM or SP_OPO_CONTINUE_ON_ERROR with 947 added into the oramsglist file.