For various reasons we have the need to delete and insert records directly through Oracle SQL for a feature class with spatial data. While exploring this option I have been warned against it because there may be orphan records that are created through ESRI that will not be created/deleted as needed when these actions are not completed through the GIS tool. Is this the case? If so, are there additional updates that could also be done directly in Oracle to account for this? We have performed a test on a small dataset to ensure that we can complete the insert/delete/truncate commands in Oracle and still have the dataset be readable through ArcGIS, no issues there. Just want to make sure we are not setting ourselves up for issues in the future by doing this. Thank you for your input in this matter.
... View more
