Re: Full export and sequence behaviour in 8i
- From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Mar 2009 09:23:11 +0400 (GST)
I have personally used sequences (9i/10g) in no gap scenarios and haven't faced
any issue. For sake of completeness I have proper alerts in place to report
missing sequences and design takes care of reusing these. users are more than
happy about this, though the alert has never puked anything till date and my
reuse logic is just waiting to be used.
Yes experience and designs differ.
Thanks
Amar
-original message-
Subject: Re: Full export and sequence behaviour in 8i
From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
Date: 16-03-2009 04:11
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:
