laptop and a wrench

Bug

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

Zuletzt veröffentlicht: August 25, 2014 No Product Found
Bug-ID-Nummer NIM055001
EingereichtMarch 5, 2010
Zuletzt geändertJune 5, 2024
Gilt fürNo Product Found
Gefunden in Version10.0 Beta
Behoben in VersionN/A
StatusFixed

Workaround

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));

Schritte zur Reproduzierung

Bug-ID: NIM055001

Software:

  • No Product Found

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln