Re: Full export and sequence behaviour in 8i
Date: Sun, 15 Mar 2009 19:46:08 -0500
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 <robertgfreeman_at_yahoo.com> 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.....
> Robert G. Freeman
> Blog: http://robertgfreeman.blogspot.com
> 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
> the law by saying you have to be a Church member. It's legal I
> promise! :-)