An other comment.
I'm designing a workflow that will allow us to publish Oracle View, registered with SDE Database, to ArcGIS Server 10.5.1, using an Oracle viewer user, not data owner.
it works quite well, but:
- if a view structure change (Field Names, format, ecc..), Arcgis says the scheme is out of date: is not possible to re-register th view, because appear already registered.
- without a tool of "Unregister with Geodatabase", we need to clean SDE metadata by commends, this with SDE credentials:
- DELETE FROM LAYERS WHERE TABLE_NAME = '<MYVIEW>';
DELETE FROM TABLE_REGISTRY WHERE TABLE_NAME = '<MYVIEW>';
DELETE FROM COLUMN_REGISTRY WHERE TABLE_NAME = '<MYVIEW>';
DELETE FROM GDB_ITEMS WHERE name = '<OWNER>.<MYVIEW>';
DELETE FROM GEOMETRY_COLUMNS WHERE F_TABLE_NAME = '<MYVIEW>';
- At this time we need to run tool "register with Geodatabase" on changed view (or python automation), this with Oracle OWNER credentials.
This is complicated for 40 views... in a system production, I have not found a faster way...
Every idea or suggestion is appreciated.
Thanks in advance..