DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Threaded View

  1. #1
    Join Date
    Apr 2003

    Better time to import

    I have an enormous file of 1.9 GB (more than 650000 records of Host's BD) that I have to import in an Oracle BD and realize calculations with its fields.
    I have tried to do it with two methods:
    1.-Using utl_file to work directly with the file
    2.-Using sql*loader to import the file to a table and work from this table.
    The two works(the second one a bit more rapid than the first one) but turn out to be very slow (1000 policies per minute) being able to be late the whole process more than 10 hours!
    How I can improve the yield of the process?

    I attach the procedure of the first method and the trigger of the second one

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.