Using the Reset Timestamps Command

Use the Reset Timestamps command from the Operation menu or click the Reset Timestamps toolbar button, to reset the timestamps in your database files. (For details, see "Resetting Timestamps", in Chapter 3.)

Use this command with care and only when it is necessary to override timestamps when files have been legitimately replaced.

To reset data file timestamps

  1. Select the Reset Timestamps command from the Operation menu or click the Reset Timestamps toolbar button. (You cannot reset timestamps if database recovery is required.) The Select Files for Timestamp Reset dialog is then displayed.

  2. If you do not want the database files in the Database Files list box at the left of the dialog sorted by file number (the default), select the Sort by file name or the Sort by file directory and name item in the Sort by drop‑down list box.

  3. Select the required database file or files whose timestamps you want reset, by performing one of the following actions.

    The selected files are then moved to the Selected files list box at the right of the dialog.

  4. To remove database files from the Selected files list box, perform one of the following actions.

    The selected file names are moved back to the Database Files list box at the left of the dialog.

  5. If you want to look for system database files, check the Show System Files check box. (By default, system files are not displayed for selection; that is, user schema files only are displayed when you first access this dialog.)

  6. If you do not want user schemas displayed for selection, uncheck the Show User Schema Files check box. (By default, user schema files are displayed for selection when you first access this dialog.)

  7. When your list of selected files is complete, click the OK button to start the operation. Alternatively, click the Cancel button to abandon your selections.

When the operation is finished, the following message is displayed in the running report.

<<Reset timestamps complete>>