[thelist] Oracle Sequences: was MySQL Tables for weblog

[Jane Williams]

On 16 Mar 2002 at 12:05, rudy wrote:

> we made that mistake, by the way, in the evolt database -- but fortunately
> in oracle the numbers aren't assigned automatically, rather they are "drawn
> from" a sequence, a stack of numbers, and this is done by the application
> sql (which is really neat, but you have to be a wacko like me to appreciate
> it), so it doesn't matter

I hope this means you wrote your own SQL, and didn't rely on an Oracle Sequence?
You did know that if you export and re-import your Oracle DB (so as to compress and
tidy up), all your sequences get re-set? We made that mistake: once and never again!