RE: [Q] why sequence number jump?

2001-03-07 Thread Trassens, Christian
nal- > De: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] > Enviado el: martes 6 de marzo de 2001 21:14 > Para: Multiple recipients of list ORACLE-L > Asunto: RE: [Q] why sequence number jump? > > do > ALTER SEQUENCE xxx nocache; > > > -Original Message-

RE: [Q] why sequence number jump?

2001-03-06 Thread Vadim Gorbounov
Sorry, overlooked this -Original Message- Sent: Tuesday, March 06, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Or, just say, "So what"? >>> [EMAIL PROTECTED] 03/06/01 03:13PM >>> do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 P

RE: [Q] why sequence number jump?

2001-03-06 Thread Tim Sawmiller
Or, just say, "So what"? >>> [EMAIL PROTECTED] 03/06/01 03:13PM >>> do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no sequence nu

RE: [Q] why sequence number jump?

2001-03-06 Thread Vadim Gorbounov
do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no sequence number probem. Recently, user complaint on couple of sequence nuber jum