Re: Moving data from DB2 to Oracle with Row Num

Yes, we can load data fine - but row nums aren't recognized.

To explain our pain, we have this application whose 'brain' is based on a couple dozen tables which do not have primary keys nor any indexes. Frankly, I've been sheltered and have never dealt with tables without PKs for determining updates/inserts.

Somehow the database keeps track of what is a new record and what is an update. On DB2 it works great: the tables know when to update and when to insert a new record.

When we load the data via SQL Loader to Oracle, Oracle starts over at 1. This creates interesting behavior in the application as another record has 1. When we apply a unique index, we then get a unique index violation - afterall there's already a record 1.

The vendor says we have to re-enter the data *by hand* ... well - it's a lot! I didn't join IT to do data entry, and I have to believe there's a way to get the row intelligence into Oracle...Isn't there?

Carole

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<uvg66avkr.fsf_at_hotpop.com>...
> On 19 Aug 2002, Carolek_at_ix.netcom.com wrote:
> > We have an application which uses Row Nums.
>
> In DB2, what's a Row Num?
>
> > 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.
>
> Have you been successful at loading the data, but unsuccessful at Row
> Num recognition?
Received on Tue Aug 20 2002 - 11:42:38 CDT