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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

LKM Sql To Sql : ORA-01031: insufficient privileges

ABABMar 25 2014 — edited Mar 28 2014

Hi,

We are trying to load data from Source Oracle DB to Target Oracle DB using following KM.

LKM : LKM SQL to SQL

IKM : IKM SQL Control Append

In Target Oracle DB we have only 'Insert Privilege' so that we could insert records into specific table.

When we try to run the ODI interface we below error -

ODI-1228: Task Move A to B fails on the target ORACLE connection TARGET_DATA_SERVER.

Caused By: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges.

When I check the Operator and session log, I noticed that LKM SQL to SQL try to Create work table in the target side somthing like ..

create table xxebs.C$_Target_Table

( Name VARCHAR2(100)

)

I believe since due to insufficient privilege it's unable to create work table and hence failing.

Do we have any workaround to handle this scenario?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2014

Added on Mar 25 2014

#business-intelligence-applications, #data-integrator, #system-management-and-integration

8 comments

1,421 views