UTL_FILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: UTL_FILE

  1. #1
    Join Date
    Sep 2000
    Posts
    77
    I created a user and gave him execute privileges for UTL_FILE
    package. But it is not working. It seems this user doesn't have permissions for writting on to the unix directory specified. How can i add this user to any unix group so that he will able to write to that directory.
    Thanks in advance.
    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The unix user that is writing to the directory is the oracle user. The oracle user must have write permission on that directory. Also, you must configure UTL_FILE_DIR in your init.ora file in order for utl_file to write...
    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."

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