Xref: alice comp.databases.oracle.tools:39429 Path: alice!news-feed.fnsi.net!netnews.com!isdnet!uu.fr!feed-uu.fr!not-for-mail From: Roland Schmidt Newsgroups: comp.databases.oracle.tools Subject: Re: select rows 770000 until 770005 in a large table Date: Wed, 02 Feb 2000 14:34:04 +0100 Organization: UUNet Lines: 29 Message-ID: <3898324C.55BC7565@hager.de> References: <3897FE06.543EFCE1@hager.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: jaydee.iway.fr 949498357 7299 194.99.49.1 (2 Feb 2000 13:32:37 GMT) X-Complaints-To: abuse@fr.uu.net NNTP-Posting-Date: 2 Feb 2000 13:32:37 GMT X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de Andy Hardy schrieb: > In article <3897FE06.543EFCE1@hager.de>, Roland Schmidt > 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