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.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *