Search code examples
plsqloracle11gutl-file

UTL_FILE_DIR on Oracle 11g SQL client

Is it possible to set up a UTL_FILE_DIR path that points to a directory on a different server than the database server?

Solution

  • Yes absolutely but the the directory must be visible and writable by the oracle user (or whatever user you are running the DB with).
    Tom Kyte wrote an amazing write up on what you can and cannot do with UTL_FILE_DIR back in 2000 but a lot of the principals are still the same.