topic Spatial view (SDE VIEW for Oracle) in Data Management Questions https://community.esri.com/t5/data-management-questions/spatial-view-sde-view-for-oracle/m-p/712564#M40338 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>I would to create a SDE View from a join between a Feature Class and an alphanumeric view, so I believe it´s possible but I need some help to move ahead and get it done...<BR />Below I am showing an error I am getting when I try to create a spatial view from sde console:</P><P></P><P>ArcSDE 9.3 for Oracle10g Build 508 Thu Apr 17 12:23:18 2008<BR />Attribute Administration Utility<BR />-----------------------------------------------------<BR /> Error: Underlying DBMS error (-51).<BR /> Error: Unable to create view sde_vw_areas_sobrepostas<BR />ORA-00907: missing right parenthesis<BR />(sde_vw_areas_sobrepostas)</P><P></P><P>This is what I'm running in the sde console:&nbsp;</P><P>sdetable -o create_view -T sde_vw_areas_sobrepostas -t tmp_areas_sobrepostas,vw_tmp_areas_sobrepostas -c tmp_areas_sobrepostas.id,tmp_areas_sobrepostas.geometry -a vw_tmp_areas_sobrepostas.projeto -w "tmp_areas_sobrepostas.projeto = vw_tmp_areas_sobrepostas.projeto" -u myUser&nbsp;-p&nbsp;myPass</P><P></P><P>Thank you in advance!</P></BODY></HTML> Mon, 29 May 2017 21:03:59 GMT WilsonCalmon 2017-05-29T21:03:59Z Spatial view (SDE VIEW for Oracle) https://community.esri.com/t5/data-management-questions/spatial-view-sde-view-for-oracle/m-p/712564#M40338 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>I would to create a SDE View from a join between a Feature Class and an alphanumeric view, so I believe it´s possible but I need some help to move ahead and get it done...<BR />Below I am showing an error I am getting when I try to create a spatial view from sde console:</P><P></P><P>ArcSDE 9.3 for Oracle10g Build 508 Thu Apr 17 12:23:18 2008<BR />Attribute Administration Utility<BR />-----------------------------------------------------<BR /> Error: Underlying DBMS error (-51).<BR /> Error: Unable to create view sde_vw_areas_sobrepostas<BR />ORA-00907: missing right parenthesis<BR />(sde_vw_areas_sobrepostas)</P><P></P><P>This is what I'm running in the sde console:&nbsp;</P><P>sdetable -o create_view -T sde_vw_areas_sobrepostas -t tmp_areas_sobrepostas,vw_tmp_areas_sobrepostas -c tmp_areas_sobrepostas.id,tmp_areas_sobrepostas.geometry -a vw_tmp_areas_sobrepostas.projeto -w "tmp_areas_sobrepostas.projeto = vw_tmp_areas_sobrepostas.projeto" -u myUser&nbsp;-p&nbsp;myPass</P><P></P><P>Thank you in advance!</P></BODY></HTML> Mon, 29 May 2017 21:03:59 GMT https://community.esri.com/t5/data-management-questions/spatial-view-sde-view-for-oracle/m-p/712564#M40338 WilsonCalmon 2017-05-29T21:03:59Z