Bulk insert into oracle database from datatable RRS feed

  • Question

  • User-793756774 posted

    I want to insert around 30K rows from system.datatable to oracle table.Can you please tell me what is the fastest way to achieve this,

    Iam using string builder and writinng 30K inserts script between Begin and End in oracle query but it is taking lot of time, more than 15 mins.

    I want it to insert in less 3 to 4 mins. Guys can you sugget me appropriate solution.

    Thanks a lot in advance.


    Tuesday, April 3, 2012 5:20 AM

All replies