Toad World® Forums

Toad Data Point - Data Compare for MDSYS.SDO_GEOMETRY Data Type

I have a database I need to compare with an older version of the same database. However one of the tables has a column of data type MDSYS.SDO_GEOMETRY. When using the Data Compare function, this table is highlighted as comparing only 4 out of 5 columns because it is unable to compare the MDSYS.SDO_GEOMETRY column.

Does anyone know of any way around this? I need to be able to see if any changes have been made in this column and currently I’m getting around this by extracting the data out and using a separate comparison tool to compare as text values.

Thanks in advance