Hi All
I have issue in ODI Process .We created a User for ODI
When i run Mapping I am getting below error
User have DROP any Table, Create any Table Privileges
Its creating C$ Table and Dropping C$ Table
User don't have " INSERT ANY TABLE" Privileges
I am having issue with DBA's they don't want to grant INSERT ANY TABLE Privileges
Please suggest
ODI-1228: Task Load data-LKM SQL to SQL- fails on the target connection OWD2.
Caused by: java.sql.BatchUpdateException: ORA-01031: insufficient privileges
Thanks for your help