Re: Does Sequence take up database storage?

In article <394796bb$0$513$7f31c96c_at_news01.syd.optusnet.com.au>,   "junwen" <junwen_at_comic.com> wrote:
> Hi,
>
> Can anybody tell me what is the use of sequence and does it take up
 any
> storage in database
> ?
>
> Regards,
> Junwen
>
>

sequences are used to generate surrogate keys in a non-blocking fashion. You use them when you want a unique numeric id for some data.

they take up a small amount of space (as all dictionary objects do) in the data dictionary.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.