The clearDeltaMode command enables you to clear the delta mode state preserved in the database control file. This may be necessary if, for any reason, it is not possible to deactivate delta mode online. A delta database allows non-permanent (or tentative) changes to be made to a database in read-only mode.
As the clearDeltaMode action is not audited, it is not replayable for archival recovery purposes.
The syntax of the clearDeltaMode command in the jdbutilb command line is as follows.
jdbutilb path=database-path
ini=initialization-file-name
clearDeltaMode
The following example shows the use of the clearDeltaMode command in the jdbutilb command line to remove any delta mode restrictions.
jdbutilb path=d:\salesdb ini=d:\salesdb\jade.ini clearDeltaMode