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

Thread: Better time to import

Threaded View

  1. #1
    Join Date
    Apr 2003
    Posts
    1

    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


    Thanks
    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