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

Description

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".

Cause

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.

Workaround