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

【解决方案】
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.

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.

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.
[/list]

【创建及修改时间】
Created: 6/7/2013

Last Modified: 12/13/2013
【原文链接】
http://support.esri.com/en/kno ... 41264