Hello Gang,

a quick question for you DB Gurus out there.

I exported an user from one instance and created a new instance and the user and imported the data back in. I noticed that the sequences were of lower values compared to the sequences in the original instance from where they were imported. It was not even the cached value that was missing, it was more than that. There was a difference of nearly 5000 when cache was just 20.

I have heard of similar problems before but generally I would have attributed it to cache. Can someone give a valid explanation please? Is there anyway that I get rid of this problem in the future (at the moment I wrote a procedure to check the max value in the table which uses the sequence and I just incremented... as in used nextval in a loop... till the sequence reached the value in the table)

thanks a million in advance
-Shyami