UTL_FILE_DIR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: UTL_FILE_DIR

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    If I set the UTL_FILE_DIR=* on my database server A, how do I put the file on somewhere else, let's say I have another computer B. How does utl_file_dir=* work???

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    http://otn.oracle.com/docs/products/...h1188.htm#7036

    In order to write on another server, you would probably have to nfs mount the other server's filesystem to your local box.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    and setting utl_file_dir=* is a REAL big security risk!
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2002
    Posts
    474
    Thanks Jeff,

    The docs didn't say much.

    Why is it a big risk to set UTL_FILE_DIR=*???


    Could you give me some reason so I can talk to the senior guy here. I ask him to set it to specific location but he want to set it to *


  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    When you set utl_file_dir=* you can open a file called '/usr/local/oracle/product/817/bin/oracle' or '/usr/local/oracle/product/817/network/admin/tnsnames.ora' and write to it. (Which, by the way, is a bad thing)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    For Your Information:

    UTL_FILE does not work over mapped drives in Windows NT, but does work OK in Windows 2000. Oracle put it down to a problem with the operating system that's out of their control.

    Also, using the JServer to access remote drives can prove tricky.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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