Javelin: Workflow Oraclebulkcopy - ORA-01031: insufficient privileges
search cancel

Javelin: Workflow Oraclebulkcopy - ORA-01031: insufficient privileges

book

Article ID: 138443

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While executing javelin workflow, i am getting the below error:

Error executing Write Data to Oracle Table: ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges

Does anyone know what grants/privileges needed for oraclebulkcopy  in target server?

Environment

All supported Javelin releases.

Cause

Permissions issue.

Resolution

 Bulk Copy some additional privileges need to be given, please review this link:


https://stackoverflow.com/questions/21530569/ora-01031-insufficient-privileges-when-bulk-loading-data-from-one-schema-to-ano


Giving full permissions should resolve this issue.