Oracle7 Server Utilities
Exporting Sequences
If transactions continue to access sequence numbers during an export, sequence numbers can be skipped. This section describes the circumstances under which it can happen. The best way to ensure that sequence numbers are not skipped is to ensure that the sequences are not accessed during the export.
Sequence Numbers Skipped
Sequence numbers can be skipped only when cached sequence numbers are in use. When a cache of sequence numbers has been allocated, they are available for use in the current database. The exported value is the next sequence number (after the cached values). Sequence numbers that are cached, but unused, are lost when the sequence is imported.