Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Chennai, India
    Posts
    2

    Post Unanswered: Reading a file using UTL_FILE.

    Hai,

    I am working in an IBM AIX machine, with Oracle 8i.
    I am trying to read a file through UTL_FILE read.
    The directory which has the file does not have any permisions for the
    others. It is restricted to 750.
    The file belongs to a local user and group.

    So, as workaround we added our local user to the secondary group of oracle, so that oracle user also has the same access permissions as the local user. But still we were not able to read the file from the procedure.

    Do we need to restart oracle ?
    will be happy if anyone can advice.

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: Reading a file using UTL_FILE.

    Is your UTL_FILE_DIR parameter correct in init.ora ?

    If not add it and restart database

    Originally posted by Anandraj
    Hai,

    I am working in an IBM AIX machine, with Oracle 8i.
    I am trying to read a file through UTL_FILE read.
    The directory which has the file does not have any permisions for the
    others. It is restricted to 750.
    The file belongs to a local user and group.

    So, as workaround we added our local user to the secondary group of oracle, so that oracle user also has the same access permissions as the local user. But still we were not able to read the file from the procedure.

    Do we need to restart oracle ?
    will be happy if anyone can advice.

  3. #3
    Join Date
    Mar 2004
    Location
    Chennai, India
    Posts
    2

    Re: Reading a file using UTL_FILE.

    Originally posted by ndu35
    Is your UTL_FILE_DIR parameter correct in init.ora ?

    If not add it and restart database
    Hai ndu35,

    Thanks for that suggestion. Anyway the entry is already present in init.ora. Also the database was restarted immediately.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •