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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > 214.954.1781 > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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" <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).