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
    Posts
    135
    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
    Posts
    22
    Hi.
    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.

    Regards.

  3. #3
    Join Date
    Apr 2002
    Posts
    135
    hi,

    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