 | |
Sequence Numbers Jumping
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: Sequence Numbers Jumping -
03-12-2008
, 05:52 PM
|
On 5 Mar, 20:55, Flash Gordon <s... (AT) flash-gordon (DOT) me.uk> wrote: [snip] There will always be gaps when using a sequence. I don't know how you managed to not have gaps using 9. Well, we were not getting anywhere near as many, or so the application people tell me. [snip] -- Flash Gordon "or so the application people tell me". That sentence sits uneasily with me. Is there anyway to verify this for yourself? HTH |
are gaps since from my knowledge of the application I believe the tables
will have timestamps. However, if the apps people are happy (which they
are now) then I really don't care as I have far bigger fish to fry. The
gaps don't really affect the end users, just the apps people who
sometimes have to look through the data to find out what has been going on.
I agree with Gints Plivna that this is a bad requirement, and I did try
to dissuade people.
--
Flash Gordon
#32
| |||
| |||
|
|
On 5 Mar, 20:55, Flash Gordon <s... (AT) flash-gordon (DOT) me.uk> wrote: [snip] There will always be gaps when using a sequence. I don't know how you managed to not have gaps using 9. Well, we were not getting anywhere near as many, or so the application people tell me. [snip] -- Flash Gordon "or so the application people tell me". That sentence sits uneasily with me. Is there anyway to verify this for yourself? HTH |
are gaps since from my knowledge of the application I believe the tables
will have timestamps. However, if the apps people are happy (which they
are now) then I really don't care as I have far bigger fish to fry. The
gaps don't really affect the end users, just the apps people who
sometimes have to look through the data to find out what has been going on.
I agree with Gints Plivna that this is a bad requirement, and I did try
to dissuade people.
--
Flash Gordon
#33
| |||
| |||
|
|
On 5 Mar, 20:55, Flash Gordon <s... (AT) flash-gordon (DOT) me.uk> wrote: [snip] There will always be gaps when using a sequence. I don't know how you managed to not have gaps using 9. Well, we were not getting anywhere near as many, or so the application people tell me. [snip] -- Flash Gordon "or so the application people tell me". That sentence sits uneasily with me. Is there anyway to verify this for yourself? HTH |
are gaps since from my knowledge of the application I believe the tables
will have timestamps. However, if the apps people are happy (which they
are now) then I really don't care as I have far bigger fish to fry. The
gaps don't really affect the end users, just the apps people who
sometimes have to look through the data to find out what has been going on.
I agree with Gints Plivna that this is a bad requirement, and I did try
to dissuade people.
--
Flash Gordon
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.