Skip to Content
0
Jan 18, 2017 at 12:14 PM

How to generate a huge continuously bigint sequence?

37 Views

Dear All,

Now I need to generate a huge continuously bigint sequence. Before I used number(), but it can only support integer not bigint, and I tried identity column but soon I found that identity gap issue hits so often. Then I tried rowid() on temp table, but there's also the gap on rowid() sorting so it can't be continuously.

Would anyone please share your idea on how to generate this bigint sequence? Thanks in advance for any help.

Regards

Eisen