Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Importing Sequences

Importing Sequences

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Sat, 20 Mar 1999 17:29:04 -0500
Message-ID: <36F42130.4E1D1768@bigfoot.com>


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?

Received on Sat Mar 20 1999 - 16:29:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US