Re: Full export and sequence behaviour in 8i

  • From: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • To: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • Date: Sun, 15 Mar 2009 19:46:08 -0500

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? 

Dan

Please excuse my typos, I sent this from my iPhone.
On Mar 15, 2009, at 7:09 PM, Robert Freeman <robertgfreeman@xxxxxxxxx> 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: 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 breaking the law by saying you have to be a Church member. It's legal I promise! :-) 



--

--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2009