Re: setting currval in a sequence without recreating the sequence

On Jul 10, 11:55 am, seannakasone
<snaka..._at_pgsnakason.hawaiianelectric.net> wrote:
> Can you set the currval in a sequence without having to drop and recreate
> the sequence?  I rather not have to drop and recreate something because I
> have to do a lot more paperwork.  Can't we just use alter or update?
> please provide example.

Can't we all just google along?

http://www.oracle.com/technology/oramag/code/tips2003/110903.html
http://www.oracle.com/technology/oramag/code/tips2004/010404.html
http://www.arikaplan.com/oracle/ari90298.html

Of course, that stuff is really old, so whether or not it works on current Oracle versions needs to be tested.

jg

--
@home.com is bogus.
http://www.sfgate.com/columnists/carroll/mondegreens.shtml