DBMS table not found (-37) - I tried to create a view

369
1
01-28-2014 11:25 PM
LaureanoRapoport
New Contributor
Hello,

I have a problem tried to create a view with ArcSDE.

I have a layer from an user on SDE instance, and a table from another instance, but i create a DBLINK to this instance and i create a SYNONIM.

When i do a sdetable -o describe from de table i see that from sde user, but when i tried to create the view:

sdetable -o create_view -T CVINCI -t INCIDENCIAS,GEVEXPED -c INCIDENCIAS.SHAPE,INCIDENCIAS.CODIGO,GEVEXPED.ESTADO -w "INCIDENCIAS.CODIGO=GEVEXPED.CODIGO" -s arcgis02 -u xxxxx -p xxxxxx

I recived the error:
DBMS table not found (-37)

I'm using ArcSDE 10.2, and a direct conection.

Any idea?

thanks.
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
I seriously doubt that DDL in the form of a CREATE VIEW statement is going to honor synonyms. There's also a problem with using 'sdetable -o create_view' with anything other than SDEBINARY/SDELOB storage, which you probably shouldn't be using at 10.2.  If the layer is using ST_GEOMETRY storage, the proper way to create a view is to use SQL to create the view, and the register the view with 'sdelayer -o register' (or use the ArcGIS equivalent). The command line tools will not be available post-10.2.x, so a new process will be necessary soon.  - V
0 Kudos