Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in Simple ODI mapping - Oracle to Oracle

vlad-mMar 13 2015 — edited Mar 17 2015

I'm new to ODI and i am trying to create a simple mapping from an Oracle table to another Oracle table on a different schema , but on same DB.

I've performed the "introductory" tutorial FILE - SQL , all went fine

But when trying to load from an oracle table to another , i get an error on the Load Data step

err1.PNG

ODI-1228: Task Load data-LKM SQL to Oracle- fails on the target connection BOOK_TARGET.

Caused By: java.sql.BatchUpdateException: ORA-00942: table or view does not exist

Connections work fine as far as i figured , when i click "View Data" in the model data in the tables shows up.

Here is a screenshot of the mapping i am trying to do :

err2.PNG

DB : Oracle 11g XE , both schemas have been granted all privileges.

ODI : 12C

Also , i had a look at what exactly the knowledge module does. I have not modified anything into it ( i have a fresh install of ODI ) . The order seams really odd to me. Why is Create work table and Drop worktable executed after Load Data?

err3.PNG

I have tried to load to another table from the same schema , it all went fine but i figured it was not using the LKM so the problem might source here.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2015
Added on Mar 13 2015
8 comments
2,232 views