AnsweredAssumed Answered

Walk only tables and feature classes, excluding views

Question asked by blake.terhune Champion on Apr 19, 2016
Latest reply on Apr 20, 2016 by bixb0012

When Walking an Oracle 11g Enterprise Geodatabase, is there a way to tell if the table or feature class you're on is actually a view? I was hoping that the canVersion dataset describe property would work, but apparently ArcGIS still thinks some views can be registered as versioned.



I did stumble across this SQL to find all the views in the (Oracle) database.

select owner||'.'||object_name as view_name
from all_objects
where object_type = 'VIEW'

I suppose I could just run that with arcpy.ArcSDESQLExecute() and then check if each object being walked is in the SQL result. Still interested in other options though.