DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unhappy Automatically upload files from a remote location to the db


    Am trying to create a database in oracle 10G and I want to load data to it from a map drive on the network.
    I would appreciate some help as to how to get the data to load automatically as it gets updated every 20 mins. The file types are .txt and every 20 mins new text files are dumped in the folder which I need to get uploaded in the db at each interval so that queries can be run on them.

    Thks in advance ..

  2. #2
    Join Date
    Mar 2002
    Mesa, Arizona
    If the same file is overwritten (updated) use an external table.

    Otherwise, you're going to need to write a script/program to loop through the files and upload them.

    Be careful you don't upload a file that is being written to.

    Why not have the program that's creating the .txt files, just insert the data directly?
    Last edited by KenEwald; 11-01-2005 at 10:05 PM.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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.