Re: select rows 770000 until 770005 in a large table

[Quoted] Tho it might not give you the information you want, you can try this:

Select * from table_name where rownum < 780000 minus
select * from table_name where rownum < 750000

This should return rows 750000 to 799999 ( assuming no inserts between the 2 select statements)  

Not very efficient and may take a long time, but it should do it...

hth,

Roland Schmidt <schmidtr_at_hager.de> wrote:

>
>
>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.
>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

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Feb 02 2000 - 18:52:28 CET