Library /sys$common/syshlp/RMUALTER72.HLB  —  COMMIT
    Writes all page changes back to the database since the last
    COMMIT or last ROLLBACK command was entered.

1  –  Description

    The results of DEPOSIT and MOVE commands are kept in virtual
    memory until you issue a COMMIT or a ROLLBACK command. When you
    issue a COMMIT command, all pages that you changed since the last
    COMMIT or last ROLLBACK command are written to the database in
    their new form.

    Changes are not permanent until you issue a COMMIT command. If
    you issue an EXIT command while altered but uncommitted pages
    exist, an error results. You cannot issue the EXIT command until
    you first issue either a COMMIT or a ROLLBACK command.

    Oracle Corporation recommends that you make a backup copy of the
    database after you issue the RdbALTER COMMIT command.

2  –  Format

  (B)0COMMIT  qqq>

3  –  Examples

    Example 1

    The following example commits all page changes entered since the
    last COMMIT or last ROLLBACK command:

    RdbALTER> COMMIT
Close Help