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?
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.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
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
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
