Utl File

[Vish_mp]

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.

[marist89]

Sure, mount your remote directory to your local machine. UTL_FILE only cares that the directory "looks" like it is local.

[TimHall]

FYI. This doesn't work on NT4.0 due to an OS issue. The problem was fixed by Microsoft in Windows 2000.

Cheers

[DaPi]

Originally posted by TimHall
This doesn't work on NT4.0 due to an OS issue. (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).