Re: many inserts into a table

From: Eric Parker <eric.parkerthedross_at_virgin.net>
Date: Fri, 1 Aug 2003 10:32:01 +0100
Message-ID: <isqWa.2408$Kx1.28845@newsfep4-glfd.server.ntli.net>

"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0307312022.3024da58_at_posting.google.com...
> oracle 8.1.7.4 (OPS environment)
>
> Ok...pls help me out on this one.
> I have one table where there can be many inserts per second. I need to
> know the order of the inserts. I cannot use date because the
> resolution is up to seconds only and I have tested
> dbms_utility.get_time and it wont work too. This will be in an OPS
> environment so, I guess sequence is out (I heard sequence is bad in
> OPS). So, what else can I do? If anyone has some sample codes to
> share, that will be great.
>
> regards
> Daud

Daud

Does your definition of 'order of the inserts' relate to when the insert statement takes place or when the subsequent commit takes place or when this transaction started ?

Perhaps if we knew what your intent was a better solution could be found.

Also what version are you running here ?

HTH eric

--
Remove the dross to contact me directly

Received on Fri Aug 01 2003 - 04:32:01 CDT