I'd like to know, if is it possible to generate and retrieve the file using UTL_FILE package in oracle on the client side?
Asked
Active
Viewed 694 times
0
Ram
- 25
- 2
- 8
-
2No, `UTL_FILE` access only the file system on database server. But you may share such directory by NFS or something similar. – Wernfried Domscheit Jul 16 '18 at 07:50
1 Answers
0
As far as I can tell, UTL_FILE operates with files on a server, stored in a directory accessible to Oracle. Therefore, you should CREATE DIRECTORY (oracle object) which points to a local directory (possibly, using UNC), grant required privileges (READ, WRITE most probably) and use that directory while working with UTL_FILE.
Littlefoot
- 131,892
- 15
- 35
- 57