English

How To: 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

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.

  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.

Related Information