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.