What effect does the “Use Immediate Database Updates” setting have on my Oracle Spatial project?
If this is toggled on, any changes made to design file elements will automatically be updated in the database. There is no need to use the Spatial Post dialog to update the information into the database as elements drawn in the design file are immediately added to the spatial database layer. In addition, as features are attached to elements in the design file, they are added to the database. Use this setting with caution, as an element that is deleted from the design file will be immediately deleted from the Oracle database.