UTL_FILE_DIR on Oracle 11g SQL client

464 views Asked by At

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

2

There are 2 answers

0
mmmmmpie On BEST ANSWER

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.

0
ryrysz On

Share directory via NFS (samba if You usingn Windows) and create symlink do this directory in Your system and set UTL_FILE_DIR to it.