Spatial view (SDE VIEW for Oracle)

05-29-2017 02:03 PM
New Contributor III

Hi everybody!

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...
Below I am showing an error I am getting when I try to create a spatial view from sde console:

ArcSDE 9.3 for Oracle10g Build 508 Thu Apr 17 12:23:18 2008
Attribute Administration Utility
Error: Underlying DBMS error (-51).
Error: Unable to create view sde_vw_areas_sobrepostas
ORA-00907: missing right parenthesis

This is what I'm running in the sde console: 

sdetable -o create_view -T sde_vw_areas_sobrepostas -t tmp_areas_sobrepostas,vw_tmp_areas_sobrepostas -c,tmp_areas_sobrepostas.geometry -a vw_tmp_areas_sobrepostas.projeto -w "tmp_areas_sobrepostas.projeto = vw_tmp_areas_sobrepostas.projeto" -u myUser -p myPass

Thank you in advance!

0 Kudos
0 Replies