The Data Dictionary uses a contents file that you specify to load sequence values into your database. Usually, this file is called _seqvals.d file.

The loading of sequence current values can accommodate 64-bit sequence values.

To load sequence values into a database:

  1. Make sure that the working database is the target database where you want to load the sequence values.
  2. Choose Admin > Load Data and Definitions > Sequences Current Values. The Data Dictionary prompts you for the filename from which you want to write the sequence values.
  3. Specify the filename or use the default value, and choose OK. After the sequence values are loaded, the Data Dictionary displays a status message and prompts you to continue.
  4. Choose OK to return to the Data Dictionary main window.
    Note: If you are loading current values into a multi-tenant sequence, in a multi-tenant database, you are asked to specify an effective tenant for the sequence values being loaded. You can specify the input location by choosing Use Default Location to have the Data Dictionary look for the sequence file in a subdirectory named for the tenant, or you can specify the input file directly.