Re: anyone seen this weirdness with sequences in 11gr2?
- From: Andre van Winssen <dreveewee@xxxxxxxxx>
- To: jkstill@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Apr 2010 14:14:26 +0200
"..you should not rely on continuity of the values from a sequence.Sequences are not guaranteed to generate all consecutive values starting with the 'START WITH' value.." 2010/4/13 Jared Still <jkstill@xxxxxxxxx> > > On Thu, Apr 8, 2010 at 3:22 PM, Robert Freeman > <robertgfreeman@xxxxxxxxx>wrote: > >> You only see this when it's associated with the creation of a table. >> Metalink document 1050193.1 explains this behavior in 11.2. >> >> > Interesting new normal behavior. > > Thanks Robert. > > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > Oracle Blog: http://jkstill.blogspot.com > Home Page: http://jaredstill.com > >
- Follow-Ups:
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: TESTAJ3
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: Niall Litchfield
- Re: anyone seen this weirdness with sequences in 11gr2?
- References:
- anyone seen this weirdness with sequences in 11gr2?
- From: TESTAJ3
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: Robert Freeman
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: TESTAJ3
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: Scott Sibert
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: Robert Freeman
- Re: anyone seen this weirdness with sequences in 11gr2?
- From: Jared Still
- anyone seen this weirdness with sequences in 11gr2?
Other related posts:
- » anyone seen this weirdness with sequences in 11gr2? - TESTAJ3
- » Re: anyone seen this weirdness with sequences in 11gr2? - Robert Freeman
- » Re: anyone seen this weirdness with sequences in 11gr2? - TESTAJ3
- » RE: anyone seen this weirdness with sequences in 11gr2? - Michael Dinh
- » Re: anyone seen this weirdness with sequences in 11gr2? - Scott Sibert
- » Re: anyone seen this weirdness with sequences in 11gr2? - Michael Moore
- » Re: anyone seen this weirdness with sequences in 11gr2? - Robert Freeman
- » Re: anyone seen this weirdness with sequences in 11gr2? - TESTAJ3
- » Re: anyone seen this weirdness with sequences in 11gr2? - Jared Still
- » Re: anyone seen this weirdness with sequences in 11gr2? - Andre van Winssen
- » Re: anyone seen this weirdness with sequences in 11gr2? - TESTAJ3
- » Re: anyone seen this weirdness with sequences in 11gr2? - Andre van Winssen
- » Re: anyone seen this weirdness with sequences in 11gr2? - Niall Litchfield
- » Re: anyone seen this weirdness with sequences in 11gr2? - Andre van Winssen
- » Re: anyone seen this weirdness with sequences in 11gr2? - Andre van Winssen