Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Posts
    13

    Unanswered: Getting error ORA-22285: non-existent directory or file for FILEOPEN operation

    Hi everyone,

    I created a directory called Templates on drive D, on the same server where my Oracle DB resides on.

    I execute the following statement...
    Code:
    CREATE OR REPLACE DIRECTORY documents AS 'D:\Templates';
    Then when I try executing the following statement, I get the error that the file or directory doesn't exist...
    Code:
    SELECT bfilename('documents', 'TS001036511.dot')
    FROM dual;
    I do have a file named TS001036511.dot in that directory, so I'm not sure why Oracle can't find it. Any ideas?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    CaSe MaTTers!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2008
    Posts
    13
    I'm sure it does, but I don't see where I have made an error with the case.

    My directory is really named Templates (with a capital T). My file is really named TS001036511.dot. Besides my Oracle DB resides on a Windows 2003 server which to the best of my knowledge is case intensive.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I don't see where I have made an error with the case.
    I can only see what you post & so far the posted details are inconclusive.
    My advice for Oracle on Windows is to ensure everything is UPPERCASE; which is NOT what you have.
    The 2 most common problems are CASE & OS file permissions.

    SELECT DIRECTORY_NAME FROM DBA_DIRECTORIES;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2008
    Posts
    13
    You sir are a genius!

    Case was the issue.

    Despite creating the directory using 'documents', when I tried using 'DOCUMENTS' it worked fine.

    Thanks again!

Posting Permissions

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