How To: In Oracle, find archive layers in load only mode
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.
The following step provides the SQL syntax for querying the ArcSDE repository tables to return a list of owner and table_names that are archive layers in load_only mode.
- Connect as the sde user in SQL*Plus and execute the following SQL statement:
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;
The rows returned represent the archive layers that are in load only mode.