Have your DBA give you all permissions on the database.
I have been doing some searches on Google and see where for 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
Let me know if this helps.
I also updated the case with this same information.
------------------------------
Technical Support Engineer III
Broadcom, Inc
------------------------------
Original Message:
Sent: 09-25-2019 04:50 PM
From: Ramamoorthy Muthusamy
Subject: Javelin workflow Oraclebulkcopy - ORA-01031: insufficient privileges
Hi Srikanth,
My DBA grant exclusive write permission to all the tables and indexes in the target schema before I create this ticket.
Is there a way to find and list what grants/privileges needed for javelin oraclebulkcopy in target server?
Thanks
Ram
Original Message------
Hi Ram,
This issue occurs due to incomplete database user privileges on target table. When you do not have exclusive write permissions to all dependent (Foreign key) TABLES, SEQUENCES and INDEXES.
To resolve this issue, You will have contact your DBA to grant exclusive write permission to all the tables and indexes in the target schema.
Thanks,
Srikanth