English

How To: Unregister autoregistered third-party Oracle Spatial tables

Summary

Instructions provided describe how to unregister tables that were autoregistered by ArcSDE and keep the table's contents. Providing the table is not versioned with uncompressed edits, the table can be unregistered with ArcSDE. Unregistered tables no longer appear as ArcSDE layers.

Note:
This procedure only unregisters Oracle Spatial feature classes that were not created by ArcSDE. Do not attempt to unregister tables that were created using ArcSDE.

Procedure

This procedure must be performed as the owner of the table.

  • Ask the ArcSDE administrator to disable autoregistration. If autoregistration remains enabled, the table may be autoregistered again after it is unregistered.
  • Revoke all privileges that other users may have on the table.
  • If using ArcSDE 9.0 or earlier, or if autoregistration is enabled, using 'sdelayer -o delete' deletes the Oracle metadata for this table from USER_SDO_GEOM_METADATA. Preserve this metadata by saving it in a new table, using SQL.
    Code:

    CREATE TABLE SAVED_METADATA AS
    SELECT * FROM USER_SDO_GEOM_METADATA
    WHERE TABLE_NAME =
    '<name of table>'
    AND COLUMN_NAME =
    '<name of spatial column>';



    Warning:
    Use caution not to use 'sdetable -o delete', or the table will be deleted.

  • Use 'sdelayer –o delete' to unregister the table. The table remains, but does not appear to ArcSDE as a layer.
  • Use 'sdetable –o unregister' to clean up any remaining entries for the table in the the ArcSDE system tables. The following message may appear, and is normal.

    Error: Layer not found (-20).
    Error: Cannot Retrieve Layer Definition for table <name>

  • If desired, replace the Oracle metadata for the table. This command inserts the metadata that was saved during an earlier step into the table SAVED_METADATA;
    Code:

    INSERT INTO USER_SDO_GEOM_METADATA
    SELECT * FROM SAVED_METADATA;

    COMMIT;


Related Information