Updating a sequence
If specified, this association replaces any previously specified association for the sequence.
(These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the sequence.
Modifies the arguments of an existing sequence object.
If the sequence was created with the CACHE option, altering the sequence will recreate the cache.
In Oracle, you can create an autonumber field by using sequences.
A sequence is an object in Oracle that is used to generate a number sequence.