Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Importing Sequences
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?
![]() |
![]() |