materialized view

[jayasudha]

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

[VinceAngelo]

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

[jayasudha]

Thanks Vince

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

[VinceAngelo]

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

[jayasudha]

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

[VinceAngelo · Accepted solution]

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