What is the importing
sequence?
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?
Ans1:
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