Update sequence set nextval

Now when the sequence object reaches 9,,,,,, it will cycle, and the next number after cycling will be the minimum of the data type, -9,,,,,, The owner realized that the bigint data type uses 8 bytes each time it is used. The int data type that uses 4 bytes is sufficient.

However the data type of a sequence object cannot be altered. To change to an int data type, the owner must drop the sequence object and recreate the object with the correct data type. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. I want to sync up the sequence number on both the databases so when the refresh occurs every morning, both the databases have same sequence number for the same record.

Is it possible to update an existing sequence to start generating new rows from a certain number? Since you can dynamically change the interval including setting it negative , you can set the increment to the difference, select from it once, then set the increment back to the correct value.

Though altering the start with clause of a sequence is not allowed, that can be done with a following trick. Get the current value of the sequence. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy.

Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options.

If neither option is specified, the current minimum value will be maintained. If neither option is specified, the current maximum value will be maintained. The clause CACHE cache enables sequence numbers to be preallocated and stored in memory for faster access.

The minimum value is 1 only one value can be generated at a time, i. If unspecified, the old cache value will be maintained. The optional CYCLE key word can be used to enable the sequence to wrap around when the maxvalue or minvalue has been reached by an ascending or descending sequence respectively.

If the limit is reached, the next number generated will be the minvalue or maxvalue , respectively. If the optional NO CYCLE key word is specified, any calls to nextval after the sequence has reached its maximum value will return an error.