Re: multiple Sequences

From: <jeanch_at_my-deja.com>
Date: 2000/04/18
Message-ID: <8dhun2$opr$1@nnrp1.deja.com>#1/1

In article <38FC41A4.27892CC4_at_web-active.com>, Martin Meister <meister_at_web-active.com> wrote:
> Got It:
>
> Oracle creates for every session an cache of sequences, by default 20.
> If you don'n use them they are lost for the next session.
>

See below that there is a no cache option when creating a sequence. In that case oracle should not cache 20 odd numbers.

create sequence fish_seq increment by 1 minvalue 1 start with 1 nomaxvalue noclycle NOCACHE noorder;

Cheers
JC
> Martin Meister wrote:
> >
> > Hi,
> >
> > i've builded a DB with several sequences, incrementig by 1.
> > When i insert a value in a table, i count the sequence on up.
> > When I work on other tables with other sequences, the first sequence
> > counts from a higher number as it should be.
> >
> > Why??
> >
> > Counts Oracle intern with one table?
> >
> > any Ideas are welcome
> >
> > martin
> >
> > --
> > Martin Meister
> > webactive GMBH
> > meister_at_web-active.com
> > www.web-active.com
>
> --
> Martin Meister
> webactive GMBH
> meister_at_web-active.com
> www.web-active.com
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 18 2000 - 00:00:00 CDT