topic migrate sde_binary to st_geometry in Data Management Questions https://community.esri.com/t5/data-management-questions/migrate-sde-binary-to-st-geometry/m-p/385997#M22150 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have installed arcsde 10 with oracle 11g and default storage configuration is ST_GEOMETRY.&nbsp; I imported my existing arcsde 9.3 database with default storage configuration as sde_binary.</SPAN><BR /><SPAN>I am able to import all the layers using oracle dmp files. I also successfully upgraded database. </SPAN><BR /><SPAN>But when I try migrate existing layer storage type from sde_binary to st_geometry, I got error as it is not supported on a view. I tried using gptool and arcsde command line and I got the same result.</SPAN><BR /><SPAN>Please provide me solution.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Kumar</SPAN></BODY></HTML> Thu, 18 Oct 2012 08:45:48 GMT GISGroup 2012-10-18T08:45:48Z migrate sde_binary to st_geometry https://community.esri.com/t5/data-management-questions/migrate-sde-binary-to-st-geometry/m-p/385997#M22150 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have installed arcsde 10 with oracle 11g and default storage configuration is ST_GEOMETRY.&nbsp; I imported my existing arcsde 9.3 database with default storage configuration as sde_binary.</SPAN><BR /><SPAN>I am able to import all the layers using oracle dmp files. I also successfully upgraded database. </SPAN><BR /><SPAN>But when I try migrate existing layer storage type from sde_binary to st_geometry, I got error as it is not supported on a view. I tried using gptool and arcsde command line and I got the same result.</SPAN><BR /><SPAN>Please provide me solution.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Kumar</SPAN></BODY></HTML> Thu, 18 Oct 2012 08:45:48 GMT https://community.esri.com/t5/data-management-questions/migrate-sde-binary-to-st-geometry/m-p/385997#M22150 GISGroup 2012-10-18T08:45:48Z Re: migrate sde_binary to st_geometry https://community.esri.com/t5/data-management-questions/migrate-sde-binary-to-st-geometry/m-p/385998#M22151 <HTML><HEAD></HEAD><BODY><SPAN>Are the tables in question spatial views? If so, the error message is accurate, and you'd need to</SPAN><BR /><SPAN>drop the view ('sdetable -o delete -t view_name'), then recreate the view (preferably with SQL, then</SPAN><BR /><SPAN>by using 'sdelayer -o register'). Be sure to convert the base layer table first.</SPAN><BR /><BR /><SPAN>-V</SPAN></BODY></HTML> Thu, 18 Oct 2012 18:35:31 GMT https://community.esri.com/t5/data-management-questions/migrate-sde-binary-to-st-geometry/m-p/385998#M22151 VinceAngelo 2012-10-18T18:35:31Z