Today, an implementation of the eldest brother in Arccatalog to rebuild a feature class, so in Arccatalog connected to the Oracle database, directly deleted the feature class, and then re-created a new feature class, but the error "table has been created", and the hint can not be in the ' Sde_ Table_registry ' table to insert duplicate key values, remember previously encountered this state, delete the incomplete, although the database in the data table deleted, can be in the SDE user in the metadata table records are not cleared, resulting in the creation of the Times wrong again.
That being the case, the relevant information is removed from the metadata table, so the relevant records in the Table_registry table are deleted from the SDE user, and a new feature is added again, this time with an error, "the layer already exists [error executing stored Procedure <schema>.layer_util.insert_layer::ora-20019:layer 4681 already exists.] "and it looks like there's a layer of information that's not cleaned up, and that's a headache, Although the stored procedure is prompted, it is not known which table the layer information is stored in ... And the lazy ghost did not go to see the specific contents of the stored procedure, the direct Google
After several searches, a command to unregister the registry with the SDE is found:
- Sdetable-o UNREGISTER-T TableName
execution, and then create the elements, sure enough, it seems, manual deletion or some not reliable AH
Then find the SDE document to see a description of this command, as follows:
Remove a table from the ArcSDE table registry
Use unregister to remove a table from the Table_registry table (sde_table_registry in SQL Server databases).
Sdetable-o unregister-t av.world-u av-p mo-i 7654
Note:tables cannot be unregistered if they has been registered as multiversioned, is part of a Geodatabase object, or H Ave a spatial column. In all cases, the dependencies must is removed first or you must use THE-F option.
To manually remove the dependencies, unregister the table from the geodatabase using ArcCatalog (if it has been registered With the Geodatabase) and remove the spatial column (if it has one) using the Sdelayer-o delete operation.
Alternatively, you can use THE-F option to force the unregistering of the table. However, when the edits is stored in the delta tables is lost. The table is not being unregistered with the geodatabase.
From
Basically, using unregister can delete a table record from the Table_registry (called Sde_table_registry in SQL Server) table, but if the deleted table is already registered as a multiple version, or as part of a Geodatabase object , or have a spatial column, they cannot be unregistered, and in any case they should be removed before they can be unregistered, or the-f option may be used. That's probably the point, but I don't know how to cancel the dependency, after all, I'm not familiar with ArcGIS.
However, from the above view, the unregister operation should not only delete the records in the Table_registry table so simple, it is estimated that some other table dependencies need to be processed, or start directly delete Table_ The records in the registry table will not still be able to create the same feature class, it seems, still do not move the SDE's metadata table is better, should try to choose to use the command-line tool provided by SDE.
When ArcGIS creates features, the prompt "table is already registered (table already registered)"