Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: resetting sequence numbers

Re: resetting sequence numbers

From: Alexandre Gorbatchev <alexandre.gorbatchev_at_avermann.de>
Date: Fri, 05 Jul 2002 07:03:35 -0800
Message-ID: <F001.004903D8.20020705070335@fatcity.com>


Yeah?
What if he had dropped the sequence, recreated it, and goddamn application didn't work because he had lost goddamn grants? Good if he knew what were these grants.

Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 05, 2002 4:20 PM

> ah jeez, you ferrin car drivers, always making thangs
> complicated when all you need is a big hammer cubic
> inch approach.
>
> What next? Setting maxvalue equal to the current
> number and selecting one number? Renaming the sequence
> and creating a synonym to point to another? Asking WHY
> he needs to do this, only to find out that the code is
> flawed since it should not rely on absolute
> serialization from a sequence in the first place, for
> god's sake?
>
> Don't you know that promoting alternate lifestyle DBA
> ideas you are encouraging the inexperienced to
> question authority and addin' to the moral corruption
> of Ameruca?
>
> Stop poisonin the newbies with fancy ideas about
> reverse select and such as that. If recreate was good
> enuf for us, it is darn sure good enuf for them!
>
> <end jingoistic rural reactionary rant>
>
>
> I slay me. I am gonna be at work in one hour, and then
> we can DO STATS!
>
>
>
>
> --- Larry Elkins <elkinsl_at_flash.net> wrote:
> > Jack,
> >
> > But then you have to redo grants, any invalidations.
> > No big deal automating.
> > But if you set the increment to a negative to take
> > you right back down to
> > zero, then set the increment to 1 (or whatever it
> > was), there you go, no
> > dropping the sequence.
> >
> > 10 to 1 odds Jared posts a nice little script that
> > automates this second
> > approach ;-)
> >
> > Regards,
> >
> > Larry G. Elkins
> > elkinsl_at_flash.net
> > 214.954.1781
> >
> > > -----Original Message-----
> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On
> > Behalf Of Jack Silvey
> > > Sent: Friday, July 05, 2002 8:03 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: resetting sequence numbers
> > >
> > >
> > > drop sequence, recreate sequence, rinse, repeat.
> > >
> > > Jack
> > >
> > >
> > > --- "Malik, Fawzia" <Fawzia.Malik_at_bskyb.com>
> > wrote:
> > > >
> > > > Hi,
> > > >
> > > > Is there a way of resetting sequence numbers
> > back to
> > > > zero???The application
> > > > we have needs to have the sequence numbers
> > reset...
> > > >
> > > > Thanks in advance
> > > >
> > > > Rgds
> > > >
> > > > Fawzia
> > > >
> > > >
> > > >
> > >
> >
> **********************************************************************
> > > > Information in this email is confidential and
> > may be
> > > > privileged.
> > > > It is intended for the addressee only. If you
> > have
> > > > received it in error,
> > > > please notify the sender immediately and delete
> > it
> > > > from your system.
> > > > You should not otherwise copy it, retransmit it
> > or
> > > > use or disclose its
> > > > contents to anyone.
> > > > Thank you for your co-operation.
> > > >
> > >
> >
> **********************************************************************
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Malik, Fawzia
> > > > INET: Fawzia.Malik_at_bskyb.com
> > > >
> > > > Fat City Network Services -- (858) 538-5051
> > FAX:
> > > > (858) 538-5051
> > > > San Diego, California -- Public Internet
> > > > access / Mailing Lists
> > > >
> > >
> >
> --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send
> > an
> > > > E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> > UNSUB
> > > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > removed
> > > > from). You may
> > > > also send the HELP command for other information
> > > > (like subscribing).
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Sign up for SBC Yahoo! Dial - First Month Free
> > > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Jack Silvey
> > > INET: jack_silvey_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Larry Elkins
> > INET: elkinsl_at_flash.net
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack Silvey
> INET: jack_silvey_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  INET: alexandre.gorbatchev_at_avermann.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 05 2002 - 10:03:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US