HOW TO

In Oracle, find archive layers in load only mode

Last Published: April 25, 2020

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.

Article ID:000010339

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic