OracleBulkCopy Privileges

I had to export an excel file into a DB. The excel file contains cross tab information. So I had to store it in the DB as normal table. When I insert row by row, it took 150 seconds for a 800 row excel file.


So decided to optimize using OracleBulkCopy. When I tested in staging server, it took only 48 seconds for the same file.


After deploying the solution in production, I was getting the following error as the production environment is using a restricted/scaled down user.

ORA-01031: insufficient privileges

Even after granting the user, Insert privilege, the same error.


Finally found out “Select” privilege is also required. Though, not sure why this is required.