topic Re: SDELOB to SDO_GEOMETRY in Data Management Questions https://community.esri.com/t5/data-management-questions/sdelob-to-sdo-geometry/m-p/631040#M35637 <HTML><HEAD></HEAD><BODY><SPAN>No, you don't want to try to read the raw LOB.&nbsp; You could certainly migrate the</SPAN><BR /><SPAN>layer storage from SDELOB to ST_GEOMETRY or SDO_GEOMETRY.&nbsp; Either would</SPAN><BR /><SPAN> then permit transfer to another table via SQL.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 23 May 2013 13:10:20 GMT VinceAngelo 2013-05-23T13:10:20Z SDELOB to SDO_GEOMETRY https://community.esri.com/t5/data-management-questions/sdelob-to-sdo-geometry/m-p/631039#M35636 <HTML><HEAD></HEAD><BODY><SPAN>Hi everyone,</SPAN><BR /><BR /><SPAN>Please forgive me, I am new to GIS. I have a table in Oracle with points stored as an SDELOB. Is there a way to read those points for a given row? I have another table that needs those points to be inserted as SDO_GEOMETRY, and I am hoping to create a trigger that can construct the SDO_GEOMETRY using the SDELOB points and insert it into the second table.</SPAN><BR /><BR /><SPAN>Any tips or advice is appreciated.</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Thu, 23 May 2013 12:52:38 GMT https://community.esri.com/t5/data-management-questions/sdelob-to-sdo-geometry/m-p/631039#M35636 JamieMason 2013-05-23T12:52:38Z Re: SDELOB to SDO_GEOMETRY https://community.esri.com/t5/data-management-questions/sdelob-to-sdo-geometry/m-p/631040#M35637 <HTML><HEAD></HEAD><BODY><SPAN>No, you don't want to try to read the raw LOB.&nbsp; You could certainly migrate the</SPAN><BR /><SPAN>layer storage from SDELOB to ST_GEOMETRY or SDO_GEOMETRY.&nbsp; Either would</SPAN><BR /><SPAN> then permit transfer to another table via SQL.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 23 May 2013 13:10:20 GMT https://community.esri.com/t5/data-management-questions/sdelob-to-sdo-geometry/m-p/631040#M35637 VinceAngelo 2013-05-23T13:10:20Z