Saving a feature class registered with move edits to base and using stand-alone log files in Oracle fails

Last Published: April 25, 2020


Saving or posting a version to the DEFAULT version with a class registered as versioned with the option to move edits to base in Oracle fails with the following underlying database error:

"ORA-00900: invalid SQL statement".


The cause is an invalid SQL INSERT statement used by ArcSDE to log modified rows with stand-alone log files. Prior to rows being written to the base state during a save operation for a class registered as versioned with the option move edits to base, ArcSDE must log each object's row_id to a log file for further data management steps. If the ArcSDE instance has been configured to use stand-alone session log files, an invalid SQL statement is executed and encounters the ORA-00900 error.


Change the ArcSDE log file settings to use the default configuration.

See the link in Related Information below on 'Log file configuration options' for more information on how to alter and set log file parameters.

    Article ID:000009702

    • ArcMap 9 x
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic