Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving data from DB2 to Oracle with Row Num

Re: Moving data from DB2 to Oracle with Row Num

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 20 Aug 2002 03:26:15 GMT
Message-ID: <rFi89.177869$sA3.245688@rwcrnsc52.ops.asp.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US