nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Encontre mais publicações marcadas com

Accepted answers

VinceAngelo

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

All comments

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

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

PaulPrevedoros1_0-1644456601455.png

jayasudha

Thanks Vince

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

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.