SDO_GEOMETRY

Compares and synchronizes Oracle data

SDO_GEOMETRY

Postby mhdelange » Wed Aug 20, 2014 2:00 pm

Has anyone did some comparisons with tables containing datatype SDO_GEOMETRY?
mhdelange
 
Posts: 2
Joined: Wed Aug 20, 2014 1:58 pm

Postby Brian Donahue » Thu Aug 21, 2014 9:05 am

Hi,

Thanks for asking. SDO_GEOMETRY is an object type and if you look in the tables section of Data Compare for Oracle, you can see that columns of this type have a \"cannot be mapped\" warning next to them. I don't believe that Data Compare for Oracle can compare object types.
describe SDO_GEOMETRY
user type definition

TYPE SDO_GEOMETRY AS OBJECT (
SDO_GTYPE NUMBER,
SDO_SRID NUMBER,
SDO_POINT SDO_POINT_TYPE,
SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,
SDO_ORDINATES SDO_ORDINATE_ARRAY,
MEMBER FUNCTION GET_GTYPE
RETURN NUMBER DETERMINISTIC,
MEMBER FUNCTION GET_DIMS
RETURN NUMBER DETERMINISTIC,
MEMBER FUNCTION GET_LRS_DIM
RETURN NUMBER DETERMINISTIC)
...
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby mhdelange » Thu Aug 21, 2014 12:24 pm

Hi,
Thanks for your reaction. I did see the warning when I try to compare two database-users. I was looking for a cause why it doesn't work :-)

Can it be, that Data Compare for Oracle can't use spatial queries to compare these colums because of the lack of 'Oracle Spatial' licensing?

Anyway, I will try to find a way around it.
mhdelange
 
Posts: 2
Joined: Wed Aug 20, 2014 1:58 pm

Postby Brian Donahue » Tue Aug 26, 2014 10:25 am

To be more precise, Data Compare for Oracle does not compare complex object types - ie datatypes that are actually composed of a list of properties having their own name and datatype. It's not specifically a lack of support for spatial objects, it's an inability to know how to compare types of data that are more complicated than just a collection of bytes that are stored in a predictable way.

For all intents though, Data Compare for Oracle would not be ab le to compare these spatial types because they use object types to hold the information and Data Compare does not support object types.

It's something that Red Gate are looking to support.
Brian Donahue
 
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests