Is This Content Helpful?
We're glad to know this article was helpful.
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.
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.
This procedure must be performed as the owner of the table.
CREATE TABLE SAVED_METADATA AS
SELECT * FROM USER_SDO_GEOM_METADATA
WHERE TABLE_NAME =
'<name of table>'
AND COLUMN_NAME =
'<name of spatial column>';
Use caution not to use 'sdetable -o delete', or the table will be deleted.
Error: Layer not found (-20).
Error: Cannot Retrieve Layer Definition for table <name>
INSERT INTO USER_SDO_GEOM_METADATA
SELECT * FROM SAVED_METADATA;