English

How To: Rename an Address Locator after it is orphaned from the geodatabase

Summary

If the following error "Address Locator already exists" is returned when attempting to rename an existing Address Locator, the locator has most likely been orphaned from the geodatabase.

Procedure

Address Locators are sometimes orphaned within the geodatabase, which restricts the user from using the preferred name for the Address Locator until it is removed from the ArcSDE Repository. The instructions provided below describe how to delete the table and rename the Address Locator.

  1. Create a generic table in the backend relational database management (RDBMS) system.

    Code:
    CREATE TABLE sample_locator_lox
    (COL1 NUMBER NOT NULL,
    COL2 CHAR(25),
    COL3 VARCHAR2(25),
    COL4 NUMBER(10,2),
    COL5 DATE,
    PRIMARY KEY (COL1),
    UNIQUE (COL3))

  2. Register the generic table from the command line of the geodatabase.

    Code:
    sdetable -o register -t <table>
    [{-c <row_id_column> -C {SDE|USER} } | {-C NONE} ]
    [-L {OFF | ON}] [-M <minimum_row_id>] [-S <table_description>]
    [-V {SINGLE | MULTI | HYBRID}] [-k <config_keyword>]
    [-H {VISIBLE | HIDDEN}] [-R {MANY | SINGLE}]
    [-y {<history_table,<history_rowid_column>,<from_date_column>,<to_date_column>}]
    [-i {<service> | <port#> | <direct connection>}] [-s <server_name>]
    [-D <database_name>] -u <DB_user_name> [-p <DB_user_password>] [-q]

  3. Open ArcCatalog, access the specified ArcSDE geodatabase, and delete the newly-registered table from the previous step.
  4. Rename the Address Locator with the desired name.