Number to cache must be less than one cycle

[Mahtab Alam]

I tried to create a sequence with cycle , so that it start again from minvalue after reaching to maxvalue.

create sequence snc start with 4 minvalue 3 maxvalue 8 cycle
But when I tried it with specifying cache option also it works.
create sequence snc start with 4 minvalue 3 maxvalue 8 cycle cache 5;
But it gives error Number to cache must be less than one cycle.

Whats the relation between cycle and cache .I think of these two options are completely separate.
Cycle is to specify what you want to do when you reach maxvalue of sequence and Cache is to specify how many numbers you want to cache in memory for some efficiency.

[Martin Vashko]

I don't get the error with the statement you've posted. I get it when I increase the cache size to 6, which is consistent with the error message.

I'd say that Oracle simply didn't bother implementing cache size larger than cycle size (you'd have to restart the sequence while filling up the cache, which might - just might - mean that the sequence needs to be updated in the data dictionary; remember that caching is a delicate stuff when concurrency needs to be handled). I believe it is an implementation detail, a decision which doesn't have some deeper meaning behind itself.