2011/9/7 Svein Erling Tysvær <svein.erling.tysvaer@...>

>
> Another thing is that I would recommend you not to use 'set generator',
> simply because it is DDL rather than DML and that there is a maximum number
> of times you can do this before you must do backup/restore. So, replace
>
>

Although Svein is almost always right about everything, in this case he's
overgeneralized a good warning. Several things in the database metadata
have limits on the number of times they can be modified, including the
number of generators you can define, but resetting a generator leaves no
traces and can be done as often as you wish.

Good luck,

Ann


[Non-text portions of this message have been removed]