UTL_FILE_DIR [message #59291] |
Mon, 10 November 2003 05:26 |
Richard
Messages: 44 Registered: May 2000
|
Member |
|
|
is it possible to set up a UTL_FILE_DIR path that points to a directory on a different server than the database server?
|
|
|
Re: UTL_FILE_DIR [message #59293 is a reply to message #59291] |
Mon, 10 November 2003 09:48 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Once the remote server's filesystem becomes available on the database server (via network mount) for read/write without any access issues, you could specify that in UTL_FILE_DIR, but not directly .
|
|
|
Re: UTL_FILE_DIR [message #60624 is a reply to message #59293] |
Fri, 20 February 2004 11:48 |
Dave L.
Messages: 11 Registered: February 2004
|
Junior Member |
|
|
I am not sure I follow the response above.
In unix, I set up a utl_file_dir to point to
another unix server that is part of my network
configuration and I get the following when I try
to access it:
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at "PRIME.PKG_CFE_XML", line 659
ORA-06512: at line 1
Writing to directories on the same server cause me
no errors.
Any help????
|
|
|