Bogue
Deleting data from an ArcSDE geodatabase for Oracle is leaving entries in the sde_xml_doc<> side tables.
| Numéro d’ID de bogue | NIM055001 |
|---|---|
| Envoi | March 5, 2010 |
| Dernière modification | June 5, 2024 |
| S’applique à | No Product Found |
| Version trouvée | 10.0 Beta |
| Version de correction | N/A |
| Statut | Fixed |
Solution de contournement
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));Étapes pour reproduire
ID de bogue: NIM055001
Logiciel:
- No Product Found
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support