CODEWITHSUNDEEP
plsqloracle11gutl-file
user4217271
user4217271

Reputation:

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?

Upvotes: 1

Views: 520

Answers (2)

mmmmmpie
mmmmmpie

Reputation: 3039

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.

Upvotes: 2

ryrysz
ryrysz

Reputation: 907

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.

Upvotes: 1

Related Questions