Re: Importing Sequences

Doug,

This is normal behavior, when you run the export, oracle looks at the DBA_SEQUENCE view (sys.seq$) to determine what the start with value should be. Because this is updated when the sequence is used, and the next cache size allocated, export looses the sequence numbers not already used.

Rgds
Andrew

Doug Cowles wrote:

> I've noticed experimenting with Personal Oracle 7.2 that if you export
> a sequence, and re-import it, it has a different albeit higher value.
> The higher number seems to be the next value evenly divisible by the
> default cache spec (in my case 20). For example, I have sequence set to
>
> a value of 5. When imported to another user, it has a value of 21.
> When I change the value to 24, and do the same thing, it has a value
> (nextval)
> of 41. Can anyone validate or comment?
>
> - Dc.
Received on Sun Mar 21 1999 - 00:07:45 CST