topic Re: materialized view in ArcGIS Enterprise Questions

materialized view

jayasudha — Thu, 04 Dec 2014 08:11:03 GMT

hi experts

I have created a materialized view in oracle 11g on a table with geometry (sdo_geometry).

It is failed when i try to register this view in arcgis 10.1 (catalog). The error is ORA - 01732 data manipulation operation is not legal on this view.

thanks

Re: materialized view

VinceAngelo — Thu, 04 Dec 2014 16:11:17 GMT

You cannot register views with a geodatabase. "Register with geodatabase" tries to add an SDE-set registered rowid column, which is not valid on a view. The supported procedure is using 'sdelayer -o register' with a USER-set rowid column, and appropriate coordinate reference parameters, etc... This will make the view contents accessible to ArcGIS as a simple feature class.

- V

Re: materialized view

jayasudha — Fri, 05 Dec 2014 05:59:58 GMT

Thanks Vince

What is entity_mask in sdelayer procedure ? What values it can take ?

Re: materialized view

VinceAngelo — Fri, 05 Dec 2014 16:23:48 GMT

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/datamgmt/sdelayer.htm

The usual values are "np", "np+", "nsl+", and "na+" for points, multipoints, lines. polygons, respectively. Add a "c" if ArcGIS will be adding CAD data.

- V

Re: materialized view

jayasudha — Mon, 08 Dec 2014 04:48:53 GMT

That is really great help, it has worked fine.

Entity mask for polygon is a (as mentioned the help doc), why do we need to use na+ ?

If base tables are updated and view is refreshed, feature class is also updated or requires any intervention ?

Thanks

Re: materialized view

VinceAngelo — Mon, 08 Dec 2014 14:23:46 GMT

It's a *mask* of permitted values. "n" to allow nil geometries (sometimes used as a place-keeper) and "+" to permit multi-part polygons (islands, not holes). If you don't use these things, then it won't fail, but if you do, then registration will fail without them.

There's no way to know what problems may be introduced by an improper "refresh" to say.

- V