In Oracle, find archive layers in load only mode

Summary

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.

Procedure

1. Connect as the sde user in SQL*Plus and execute the following SQL statement:
   
   

   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

   
   
   The rows returned represent the archive layers that are in load only mode.