The compare errors out with the following errors showing up in "show compare" and the *desvr* log (compare log on source) respectively:
sp_ctrl>show compare
37519596.250 "AR"."HZ_LOCATIONS" Unsupport 08-Sep-09 12:14:40
The corresponding *desvr* log:
.
.
250: Notice: Object ID of "AR"."HZ_LOCATIONS" is 1141234
250: Skip LOB column(s) : Off
250: Log source rowid : On
250: WARNING: Found column[105] (GEOMETRY) of unsupported type 108 (de_table_ask_info,L2624)
250: DEBUG:schema=AR, table name=HZ_LOCATIONS, column_count=111 (de_table_list_table_info,L3592)
.
.
Compare is run on a table with unsupported datatype as far as compare is concerned.
Even though certain datatype may be ok for replication, it is quite possible that they are not supported by compare. In this case the column GEOMETRY is of the type SDO_GEOMETRY which is not supported by compare. Compare does not support UDT or VARRAY columns. To sync such tables use means other than compare, such as copy, Oracle Export/Import, hotbackup reconcile, etc.
See Release Notes for any exclusions in terms of datatype, etc for compare.
