AnsweredAssumed Answered

Spatial view (SDE VIEW for Oracle)

Question asked by wilsoft on May 29, 2017

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!

Outcomes