Create Database View 10.1 (Oracle, ST_Geometry, Feature Class)

1941
12
07-28-2014 02:15 PM
SandraLuken
Occasional Contributor

According to the online help documentation, it seems possible that a spatial view against an Oracle/non-versioned/registered with the GDB/st_geometry/feature class is possible. The view creates without error, but cannot be viewed afterwards, giving a generic 'cannot display' error message. The user that is attempting to create the view has create view privileges.

Are we mis-reading the help documentation? Is this possible with our configuration? Sure we know that spatial views can be created at the command line, but are more interested in the desktop tool solution rather then the soon to be deprecated command line tools.

ArcGIS Desktop 10.1 SP1 (no QIP)

ArcSDE 10.0 SP5

0 Kudos
12 Replies
AsrujitSengupta
Regular Contributor III

Just to add to what Vince already mentioned, that View created using ArcGIS Desktop can be previewed in ArcMap w/o any issues. Basically thats going to act as a Query layer,as he pointed out, but will work fine.

Incase this helps or thats what you needed.

SandraLuken
Occasional Contributor

Thank you to both of you for your time and effort to help clarify things. In the end this comes down to a difference in expected behaviour based on what is written in the document. Short answer, ArcGIS cannot do what I want/expect it to do when it comes to Spatial Views without the involvement of the SDE command line. Perhaps in a future release.

0 Kudos
ForrestJones
Esri Contributor

Hi Sandra,

This should work. A few things to check:

-Are you using an application server connection? Try using a direct connection instead. This might be the problem.

-Are there any errors in the sde error log? For direct connections it will be on your arcgis client machine in the %temp% directory (app server in sdehome\etc)

-If it still fails and there is nothing helpful in the sde dc error log, I would suggest opening an incident so we can look into it further.

Thanks.