topic Re: Incomplete ROWID extraction from Oracle source in Qlik Replicate

Incomplete ROWID extraction from Oracle source

gm908 — Thu, 05 Sep 2024 12:57:02 GMT

We followed the steps outlined in the Transformation: Source Lookup - Oracle ROWID article to extract the ROWID value, however roughly half the values came back as NULL.

Our primary key columns were used as the conditions for the lookup and the ROWID was unique on the Oracle side.

Is there a limitation preventing the ROWID from matching?

Re: Incomplete ROWID extraction from Oracle source

john_wang — Thu, 05 Sep 2024 15:29:25 GMT

Hello @gm908 ,

Thanks for reaching out to Qlik Community!

ROWID is an internal data type in Oracle that represents the physical address of a row within a table. When replicating ROWID to another database, especially a non-Oracle database, the value becomes meaningless because it is specific to Oracle's internal storage architecture. Could you please clarify why you need to replicate the ROWID?

Regards,

John.

Re: Incomplete ROWID extraction from Oracle source

DesmondWOO — Mon, 09 Sep 2024 04:11:09 GMT

Hi @gm908 ,

Oracle ROWID can change if the row is physically moved, such as when the table is altered to reduce its size. This can lead to a mismatch in the ROWID.

Regards,
Desmond