Bulk upload of files to Oracle and access remote server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Bulk upload of files to Oracle and access remote server

  1. #1
    Join Date
    May 2007
    Posts
    3

    Bulk upload of files to Oracle and access remote server

    i want to upload files to Oracle DB on Solaris, by using Bulk Upload!
    the thing is that the files are on another server and can't be moved to the Solaris server with the oracle!
    how can i solve thios problem>?

    thnaks in advance
    peleg

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    what files? and put them where?

  3. #3
    Join Date
    May 2007
    Posts
    3
    i have files with data for example :
    data1data2......
    in a text file and i want to insert them to the Oracle as i do in sql server with "bulk upload"
    but the thing is that i want to to this upload to the server not from the server where the oracle is but from another server .

  4. #4
    You'll want to use SQLLoader. You'll install the oracle tools on some other server and use sqlldr to parse and upload them.

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