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.

 

 

34 thoughts on “OracleBulkCopy Privileges

  1. a bathing ape

    My spouse and i felt so thrilled when Albert managed to conclude his survey while using the precious recommendations he made through your web site. It’s not at all simplistic just to possibly be releasing hints which usually many people have been making money from. We really realize we’ve got you to be grateful to for this. The entire illustrations you have made, the straightforward blog menu, the relationships you make it possible to instill – it’s mostly powerful, and it’s letting our son and our family feel that the subject matter is interesting, and that’s unbelievably fundamental. Many thanks for everything!

  2. moncler outlet

    I precisely needed to thank you very much once again. I am not sure the things that I would’ve taken care of in the absence of the actual advice provided by you about my situation. It had been the challenging case in my circumstances, nevertheless considering the very specialised form you solved the issue made me to cry over joy. I’m happier for the guidance and even trust you are aware of a great job that you are providing teaching many others using your websites. More than likely you haven’t met all of us.

  3. pandora

    I have to express some thanks to the writer just for bailing me out of such a problem. Just after checking throughout the online world and finding basics which were not productive, I thought my life was done. Existing without the answers to the problems you’ve fixed by way of your entire site is a critical case, as well as the kind which may have negatively affected my entire career if I had not discovered the blog. Your primary skills and kindness in controlling a lot of stuff was precious. I am not sure what I would’ve done if I hadn’t come upon such a solution like this. I am able to at this time look forward to my future. Thanks for your time very much for this professional and amazing guide. I will not be reluctant to propose your web sites to anybody who needs and wants guidance on this subject matter.

  4. off white x nike

    I in addition to my pals came reviewing the excellent pointers located on your web site and so the sudden I had a terrible feeling I never expressed respect to the web site owner for them. My men became absolutely happy to study all of them and have in fact been using them. I appreciate you for being really accommodating as well as for figuring out this form of helpful useful guides most people are really wanting to discover. My personal honest regret for not expressing appreciation to you sooner.

  5. curry 7 shoes

    A lot of thanks for every one of your efforts on this web site. My mom takes pleasure in conducting investigation and it’s simple to grasp why. We learn all of the dynamic medium you offer valuable items through this blog and in addition encourage participation from some others on that matter plus our own child is undoubtedly starting to learn a whole lot. Take pleasure in the remaining portion of the year. You are doing a splendid job.

  6. chrome hearts online store

    A lot of thanks for every one of your labor on this blog. My mum really loves conducting investigations and it is easy to see why. Many of us notice all regarding the lively mode you create helpful guidance via your blog and as well strongly encourage response from other people on the matter so our favorite princess is being taught a great deal. Have fun with the remaining portion of the year. You have been performing a good job.

  7. kd shoes

    I am writing to make you understand of the brilliant experience my cousin’s child found reading your blog. She figured out some details, including what it is like to have a great giving mood to have many people effortlessly master some complex subject matter. You really did more than our expected results. I appreciate you for distributing these useful, safe, revealing and in addition easy thoughts on that topic to Mary.

  8. kobe 9

    Thanks a lot for giving everyone remarkably terrific possiblity to read articles and blog posts from this website. It really is so terrific and also jam-packed with fun for me personally and my office mates to search your website more than three times in a week to find out the latest things you will have. Of course, I’m just actually motivated with your fabulous concepts served by you. Selected 2 areas in this post are rather the very best we have all had.

  9. kobe byrant shoes

    I have to express appreciation to the writer just for rescuing me from such a difficulty. Just after surfing around throughout the search engines and obtaining solutions that were not productive, I figured my entire life was gone. Being alive devoid of the answers to the problems you’ve solved all through your entire guideline is a critical case, as well as ones that would have in a wrong way affected my career if I hadn’t noticed the blog. Your actual training and kindness in controlling almost everything was tremendous. I’m not sure what I would’ve done if I had not encountered such a step like this. I am able to at this time look forward to my future. Thanks so much for the expert and amazing help. I will not be reluctant to recommend the website to anybody who would need direction on this situation.

  10. moncler outlet

    I together with my buddies were looking through the best tricks found on the blog while instantly I got a horrible feeling I never expressed respect to the blog owner for those secrets. The boys ended up as a result thrilled to study them and have now actually been using those things. Thank you for being very thoughtful and then for making a choice on varieties of fantastic areas millions of individuals are really eager to learn about. My sincere regret for not expressing gratitude to you earlier.

Leave a Reply to bimatoprost cvs Cancel reply

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