Is This Content Helpful?
We're glad to know this article was helpful.
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.