Alexandre, Take it easy, just a little friday humor. All ways have their advantages and disadvantages.
jack --- Alexandre Gorbatchev <[EMAIL PROTECTED]> wrote: > 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 > === message truncated === __________________________________________________ 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).
