Is there a way by which I can write MY UTL FIle Output into another UNIX Machine/SERVER and a different PATH?
Note: Not on the same UNIX machine where Oracle Server resides .This is entirely a diferent UNIX machine.
Printable View
Is there a way by which I can write MY UTL FIle Output into another UNIX Machine/SERVER and a different PATH?
Note: Not on the same UNIX machine where Oracle Server resides .This is entirely a diferent UNIX machine.
Sure, mount your remote directory to your local machine. UTL_FILE only cares that the directory "looks" like it is local.
FYI. This doesn't work on NT4.0 due to an OS issue. The problem was fixed by Microsoft in Windows 2000.
Cheers
(Odd coincidence I wanted to do this today!) Thanks to sem (Dima) in the tek-tips 8i forum: the solution is to run the Instance and Listener NT services as a non-SYSTEM user, member of the local administrators group and with "log on as a service" priviledge. It works for both mapped drives and "url" format. (tested with 8.1.7.4 under NT 4.0 Sp6a).Quote:
Originally posted by TimHall
This doesn't work on NT4.0 due to an OS issue.