Error Using ODI JKM Oracle 10g Consistent (Logminer) on Tables with PK Defined on all Columns
(Doc ID 578833.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.4.2 to 10.1.3.9.99Information in this document applies to any platform.
Symptoms
When using the JKM Oracle 10G Consistent Logminer provided by Oracle Data Integrator (ODI) on a table made by columns which are all part of the Primary Key, the "Create View" step generates a wrong code.
For example, if <TABLE> is composed by only two columns (<COL1> and <COL2>) and both of them build the PK, the SQL code generated by ODI contains a comma after the latest column in the Select order, which is syntactically incorrect:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |