topic Using non spatial view in sde in Data Management Questions https://community.esri.com/t5/data-management-questions/using-non-spatial-view-in-sde/m-p/705112#M39955 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guru..</SPAN><BR /><BR /><SPAN>I have a scenario like this.I have sde and non spatial attributes in different database.</SPAN><BR /><SPAN>How can i use the oracle attributes in sde environment.</SPAN><BR /><SPAN>I able to create view in sde from non spatial database but it can't be used in sde..</SPAN><BR /><SPAN>Please guide..thanks.</SPAN></BODY></HTML> Tue, 01 Mar 2011 23:45:50 GMT mohd_syafidabdullah 2011-03-01T23:45:50Z Using non spatial view in sde https://community.esri.com/t5/data-management-questions/using-non-spatial-view-in-sde/m-p/705112#M39955 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guru..</SPAN><BR /><BR /><SPAN>I have a scenario like this.I have sde and non spatial attributes in different database.</SPAN><BR /><SPAN>How can i use the oracle attributes in sde environment.</SPAN><BR /><SPAN>I able to create view in sde from non spatial database but it can't be used in sde..</SPAN><BR /><SPAN>Please guide..thanks.</SPAN></BODY></HTML> Tue, 01 Mar 2011 23:45:50 GMT https://community.esri.com/t5/data-management-questions/using-non-spatial-view-in-sde/m-p/705112#M39955 mohd_syafidabdullah 2011-03-01T23:45:50Z Re: Using non spatial view in sde https://community.esri.com/t5/data-management-questions/using-non-spatial-view-in-sde/m-p/705113#M39956 <HTML><HEAD></HEAD><BODY><SPAN>Views across DATABASE LINKs are possbile, but usually perform poorly if not </SPAN><BR /><SPAN>carefully tuned.&nbsp; </SPAN><BR /><SPAN> </SPAN><BR /><SPAN>You cannot use the ArcSDE API to create a database link view, but you can create</SPAN><BR /><SPAN>a dummy table with the same columns (and same types), create_view to that, then </SPAN><BR /><SPAN>edit the view in SQL Developer, etc... so that it crosses databases.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Wed, 02 Mar 2011 10:32:02 GMT https://community.esri.com/t5/data-management-questions/using-non-spatial-view-in-sde/m-p/705113#M39956 VinceAngelo 2011-03-02T10:32:02Z