Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sequence Number Loss

Sequence Number Loss

From: zhan <zhang_at_visi.net>
Date: Fri, 08 Jan 1999 02:18:43 GMT
Message-ID: <369593FD.4831@visi.net>


Hi, Everyone,

 I have a problem with Oracle Sequence number:  

 Enviroment: Oracle 8 in Sun E3000 server with Solaries2.6.  Problem: When Oracle is shutdown ( "shutdowm immediate")

         for a cold backup, Oracle sequences seem lose some
         number( advace some number), sometimes OK, and 
         other times very bad. Our users are not happy about some
         numeric sequence numbers( like account#) because they are
         not consecutive.
 Suggestions sought: we want to use Sequence as our primary key 
         source because they are guranteed to be unique and
         have good perfomance, but we also want the number to
         be consecutive( at least most of the time). Any suggestions
         and advices are highly appreciated.

  from: Sean Zhang
  <zhang_at_visi.net> Received on Thu Jan 07 1999 - 20:18:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US