Re: Full export and sequence behaviour in 8i

From: Dan Norris <>
Date: Sun, 15 Mar 2009 19:46:08 -0500
Message-Id: <>

Hi Robert,

Never is a word I don't see too often. I think a "nocache order" sequence is better and more reliable than any other method I've seen. What approach would you use instead to have a no-gap list of numbers guaranteed?


Please excuse my typos, I sent this from my iPhone.

On Mar 15, 2009, at 7:09 PM, Robert Freeman <> wrote:

> You should never use a sequence if what you want is an assured
> serial number with no gap.
> There are a number of ways to loose a number in a given sequence.....
> RF
> Robert G. Freeman
> Author:
> Blog:
> OCP: Oracle Database 11g Administrator Certified Professional Study
> Guide (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Features (Oracle Press)
> Other various titles out of print now...
> The LDS Church is looking for DBA's. You do have to be a Church
> member in
> good standing. A lot of kind people write me, concerned I may be
> breaking
> the law by saying you have to be a Church member. It's legal I
> promise! :-)
> --
> --

Received on Sun Mar 15 2009 - 19:46:08 CDT

Original text of this message