HOW TO
It may be necessary to use a SQL statement to discover the name of all the archive layers that are currently in load only mode.Instructions provided describe how to query the ArcSDE repository tables to discover which archive layers are in load only mode.
Code:
SQL> SELECT a.owner OWNER, a.table_name TABLE_NAME
2 FROM sde.table_registry a, sde.layers b
3 WHERE BITAND(b.eflags,1074790400) = 1074790400
4 AND BITAND(a.object_flags,1048576) = 1048576
5 AND a.owner = b.owner
6 AND a.table_name = b.table_name;
OWNER TABLE_NAME
-------------------- --------------
BRENT PARKS_H
Article ID:000010339
Get help from ArcGIS experts
Download the Esri Support App