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
(sde_vw_areas_sobrepostas)
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.id,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!
