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: Jack Silvey <jack_silvey_at_yahoo.com>
Date: Fri, 05 Jul 2002 06:23:25 -0800
Message-ID: <F001.00490341.20020705062325@fatcity.com>


Fawzia,

you might investigate why the code would rely on an unbroken string of numbers from a sequence, with all the attendant problems, such as number loss from rollback or the ever present caching issues. This might prevent issues such as this in the future.

jack

> > 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).
>
> --
> Daniel Wisser, Mag.
> Papyrus Quality Assurance
> DB Team
>
> ISIS Information Systems
> Alter Wienerweg 12
> A-2344 Ma. Enzersdorf, Austria
>
> Phone: +43-2236-27551-149
> Fax: +43-2236-21081
> E-mail: daniel.wisser_at_isis-papyrus.com
>
> Hotline: +43-2236-27551-111
>
> Visit the ISIS Website: http://www.isis-papyrus.com
>
>


> This e-mail is only intended for the recipient and
> not legally
> binding. Unauthorised use, publication, reproduction
> or
> disclosure of the content of this e-mail is not
> permitted.
>


> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Daniel Wisser
> INET: daniel.wisser_at_isis-papyrus.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).
Received on Fri Jul 05 2002 - 09:23:25 CDT

Original text of this message

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