Re: HELP: How to generate sequential Primary Keys on a maste

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Sat, 06 Apr 2002 15:05:30 GMT
Message-ID: <1018105530.6006snx_at_aleytys.pc.my>

In article <6asrau4lfelqqtptocr3h3hqbt1ccdncth_at_4ax.com> postbus_at_sybrandb.demon-verwijderdit.nl writes:
>On Mon, 01 Apr 2002 16:09:51 GMT, IF <tlfbi98_at_terra.es> wrote:

>>We cannot use Oracle Sequences because we cannot lose any value in the
>>sequence. Therefore, in order to generate the sequential values for
>>the primary key, we have to use a value stored in another table.

>rubbish. Create sequence ... nocache ordered.

[Quoted] So, um will a transaction rollback also rollback a sequence? There are certain occasions where your external auditor (unless it's AA) won't accept "That's the way sequences work" as a reason why there are missing numbers in your financial transactions.

Philip

---=====================================================================---

[Quoted]  Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

-- 
 þ 20442.88 þ New mail not found. Start whine pout sequence? (Y/N)

Received on Sat Apr 06 2002 - 17:05:30 CEST