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.