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

Home -> Community -> Usenet -> c.d.o.misc -> unsequential sequences

unsequential sequences

From: Kevin Blount <kevin_at_questionmark.com>
Date: 8 Jul 2005 13:23:06 -0700
Message-ID: <1120854186.849320.167890@o13g2000cwo.googlegroups.com>


This may have aked before, but my searching for such threads didn't get the help I need, so here we go (again):

I have a sequence and trigger that allow me to automatically assign an "ID" to a table record. The sequence has the following properties (let me know if I missed anything out)

minimum     = 1
maximum     = 1.0E28
interval    = 1
last number = 281

cycle values = unselected
order values = unselected
Cache        = default

the problem is that the IDs created tend to a) end in 1 and b) jump 20 numbers.

if I were to insert a new record on two different days, the changes are that the IDs would be 301 and 321 (based on the last number above). However, if I were to add them both at the same time, or within a small time period) they would probably be 301 and 302.

My DB admin has spotted the issue, but doesn't know the cause or the fix.

Can anyone help? I doesn't really effect any of the scripts I'm writing, but when those IDs are visible it make my applications look wierd, when 90% of the assigned IDs end in 1, ya dig?

thanks for reading.. many thanks for replying :) Received on Fri Jul 08 2005 - 15:23:06 CDT

Original text of this message

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