Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert Oracle Spatial heterogenous collection (2004) to multiline string (2006)

1010855Aug 21 2013 — edited Aug 28 2013

Hi,

I have all the SDO geometries in 2004 (heterogeneous collection) gtype and I want to convert all the geometries to 2006 (multiline string) gtype since the consuming application can't render 2004 gtypes. I am running a update query to change the gtype from 2004 to 2006, keeping SDO_SRID, SDO_POINT, SDO_ELEM_INFO and SDO_ORDINATES as the same. I have tested the multiline string (2006) geometries in a viewer and the shape remains the same.

Are there any caveat that I am missing, where there is a possibility that the shape may get changed? Please give me some pointers if there are any other solution of converting 2004 gtypes to 2006.

Regards,

Ananda

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2013

Added on Aug 21 2013

#database-key-features, #spatial

4 comments

3,012 views