Skip to Content
0
Former Member
Mar 16, 2015 at 01:16 PM

ORA-01031 Insufficient Privileges when doing a direct dump from table to table

311 Views

Hi All,

We are doing a data dump from table to table. There no transformation involved.

The Dataflow includes only below objects

1. Source Table

2. Query Transform

3. Target Table

Since, it is a direct a dump, insert query is pushed to database.

We are getting below error when the insert query is pushed to database.

We are able to insert data into target table, When I avoided push down to database.

Not sure, if this is a Oracle Schema access issue (or) BODS issue.

Could you please help us in fixing this issue.

Appreciate your Help...

Attachments

Capture.PNG (177.3 kB)