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