Re: select rows 770000 until 770005 in a large table

Andy Hardy schrieb:

> In article <3897FE06.543EFCE1_at_hager.de>, Roland Schmidt
> <schmidtr_at_hager.de> writes
> >In Oracle 8.0.5 I need to select some rows from a large table starting
> >with the 770000th row in this table without knowing the key.
>
> If you don't have a key why do you want the 770000th row?
>
> In an RDBMS the concept of the 770000th row does not really mean
> anything, what are you trying to achieve?
>
> Andy
> --
> Andy Hardy. PGP key available on request
> ===============================================================

I want to get the key.
[Quoted] The reason is a problem during a Software upgrade (SAP). In our test system everything works well and in our production system the upgrade stopped with an error due to create the primary index after inserting 770005 rows.
Now I try to find out why it works in one system and not in the other. I may help to get the key of row 770006, you know ?

Roland Received on Wed Feb 02 2000 - 14:34:04 CET