NIM055001 for No Product Found

漏洞 ID 编号	NIM055001
已提交	March 5, 2010
上次修改时间	June 5, 2024
适用范围	No Product Found
找到的版本	10.0 Beta
修正版本	N/A
状态	Fixed

解决办法

Run these queries first (as the sde user) to see how many records are orphaned:select count(*) from sde_xml_doc1 where sde_xml_id not in (select sde_xml_id from sde_xml_doc1 where sde_xml_id in (select definition from sde.gdb_items));select count(*) from sde_xml_doc2 where sde_xml_id not in (select sde_xml_id from sde_xml_doc2 where sde_xml_id in (select documentation from sde.gdb_items));select count(*) from sde_xml_doc3 where sde_xml_id not in (select sde_xml_id from sde_xml_doc3 where sde_xml_id in (select iteminfo from sde.gdb_items));select count(*) from sde_xml_doc4 where sde_xml_id not in (select sde_xml_id from sde_xml_doc4 where sde_xml_id in (select attributes from sde.gdb_itemrelationships));============Run the following sql (as the sde user) to clean up the tables. This will delete orphaned xmldocs:delete from sde_xml_doc1 where sde_xml_id not in (select sde_xml_id from sde_xml_doc1 where sde_xml_id in (select definition from sde.gdb_items));delete from sde_xml_doc2 where sde_xml_id not in (select sde_xml_id from sde_xml_doc2 where sde_xml_id in (select documentation from sde.gdb_items));delete from sde_xml_doc3 where sde_xml_id not in (select sde_xml_id from sde_xml_doc3 where sde_xml_id in (select iteminfo from sde.gdb_items));delete from sde_xml_doc4 where sde_xml_id not in (select sde_xml_id from sde_xml_doc4 where sde_xml_id in (select attributes from sde.gdb_itemrelationships));

重现步骤

漏洞 ID: NIM055001

软件:

No Product Found

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项

Deleting data from an ArcSDE geodatabase for Oracle is leaving entries in the sde_xml_doc<> side tables.

解决办法

重现步骤

当漏洞状态发生变化时获得通知

发现关于本主题的更多内容