Re: How to know what sequence a table is using?

gazzag wrote:
> Yes. Each session caches or "reserves" 2000 sequences when required.
> This is to ensure that each session has a cache of unique seqence
> numbers, so there is no duplication. The next session will take the
> next 2000, and so on.
>
> Some useful documentation about sequences can be found here:
>
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref883
>
> One final thing, the etiquette in this newsgroup requires that you do
> not "top-post". Please place any replies _beneath_ the text that you
> are quoting. You will find it will be very much appreciated :-)
>
> HTH
>
> -g

Hi,

Thank you for your explaination. I got more of how sequence works now.

Thank you for letting me the etiquette in newsgroup because this is my first posting in google newsgroup. ^_^ ..

Crystal Received on Thu Jan 18 2007 - 15:37:01 CST