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)0[m[4mCOMMIT[m qqq>
3 – Examples
Example 1 The following example commits all page changes entered since the last COMMIT or last ROLLBACK command: RdbALTER> COMMIT