utl_file_dir problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: utl_file_dir problem

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    utl_file_dir problem

    Hi DBAs,

    The developers keep complaining about that they cannot write files
    to some directories which I verified specified in init parameter file.
    We define a lot of directories contiguously in the parameter file.

    The problem is that:
    use: show parameter utl_file_dir;
    It turns out only half of them specified in the init file.
    It looks like be cut off.

    Is there any limit about the number of directory specified in the
    init file?

    Thanks,

    Lily

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,026
    Is is possible that one of the UTL_FILE_DIR parameters points to an invalid directory. You should make sure that all of the directories can be reached from the database server.

    I'm not aware of a maximum number of directories that you can reference with UTL_FILE_DIR.

    Also, If you are using 9i a better way to give file acces to programs is to use the CREATE DIRECTORY command and create a directory pointer for every dirctory where you need to give access.

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,026
    In case you are interested here is a link to tahiti with more information on CREATE DIR

    tahiti.oracle.com

  4. #4
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thanks for the reply.

    I checked the operating system. All the directories are there and
    the mode is fine.

    I just join the team in the middle of the development process. Personally I like the way-create directory.

    I did some experiments.
    I changed the sequence of the utl_file_dir specified in the init
    file. It is always cut off at the point of specifying
    the 16th utl_file_dir.

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,026
    This note is from Tahiti.oracle.com.

    Note:
    If you list multiple values, all entries of this parameter must be on contiguous lines of the parameter file. If you separate them with other parameters, Oracle will read only the last (contiguous) lines.

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