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
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 :
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?
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.