bulk insert problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: bulk insert problem

  1. #1
    Join Date
    Apr 2002
    I was using SQLServer.
    Now i am migrating it to Oracle.

    I need to do bulkinsert from a text file into a Table.
    in SQLServer there was bulkinsert command.

    In oracle i tried UTL package.But it was very slow.

    I tried SQLLoader in CMd prompt it was quite fast.
    But how to use inside my procedure.
    Ie. calling thesqlloader from inside my procedure.
    Is there any way of doing it.

  2. #2
    Join Date
    Nov 2000
    You can run SqlLoader (or any other executable)
    from within Oracle using ExtProc Listener.

    If you have 9i you can use External tables feature, which
    allows to manipulate data without loading it into DB.


  3. #3
    Join Date
    Apr 2002

    can you explain about how to use it .B'cos i am not familiar with it.

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