Re: multiple Sequences

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.

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