Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving data from DB2 to Oracle with Row Num
You need to read about what rownum is. Rownum is the number of the row in
the result set. What you are implying is that rownum has some sort of
concept with the order of the physical data. (by definition data in tables
is unordered and queries can ask for sets of it in a particular order.)
Jim
"Carole Kaufman" <Carolek_at_ix.netcom.com> wrote in message
news:df145ded.0208191717.14439b56_at_posting.google.com...
> We have an application which uses Row Nums. We've been unsuccessful
> at moving the data from DB2/OS390 and loading the data into Oracle 9i
> via SQL Loader, but we can't get it to load into Oracle with row num
> recognition. As a result, the application begins building data again
> at 1 rather than the appropriate row num number.
>
> How can we move the data from DB2/OS390 over to Oracle with row nums?
>
> Thanks,
>
> Carole
Received on Mon Aug 19 2002 - 22:26:15 CDT