注册

  HowTo:  Remove orphaned objects (feature classes) from a geodatabase

【相关信息】
Article ID: 41265
Software:
ArcSDE 9.3.1, 10, 10.1, 10.2
Platforms:
Windows Server 2003, Vista, Server 2008, Windows 7

【问题描述】
In the event of data or users being removed from a back-end database, geodatabase objects are sometimes orphaned. The most likely causes for this are:
• The objects were unintentionally dropped by a user with a SQL command.
• During database migration, the geodatabase objects were lost.
2015-11-19 添加评论
分享

没有找到相关结果

    已邀请:

    易智瑞技术支持

    赞同来自:

    【解决方案】
    The instructions provided describe how to remove an orphaned object from a geodatabase.


    1. Use 'sdetable -o delete' as the data owner to delete the orphaned table: sdetable -o delete -t <orphaned_table_name> [-s <server_name>][-i {<service> | <port#> | <direct connection>}][-D <database_name>] -u <DB_user_name> [-p <DB_user_password>] [-N] [-q]
    2. In the back-end database, use SQL to create a table with the same name as the orphaned object. CREATE TABLE <orphaned_table_name>(column_name1 data_type,column_name2 data_type,column_name3 data_type,....)
    3. Use ArcCatalog to delete <orphaned_table_name>.
    4. To add the feature class back in to the geodatabase, create the feature class in ArcCatalog with the same name.


    【其它相关参考】
    1. Geodatabase upgrade fails with "Could not update server tables and stored procedures. Error (-238)"
    2. HowTo: Determine if there are orphaned replica system versions in the geodatabase


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

    Last Modified: 12/18/2013
    【原文链接】
    http://support.esri.com/en/kno ... 41265
    回复时间：2015-12-05 17:38:48 0 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册


    Copyright © 2025