| Creating files in remote directory in UNIX using UTL_FILE [message #42858] |
Thu, 15 May 2003 10:02  |
priya
Messages: 108
Registered: February 2000
|
Senior Member |
|
|
I would like to create file in a remote directory using a UTL_FILE package from a procedure.
How is it possible?
If I want to give the remote directory name in the UTL_FILE_DIR parameter in the init.ora file,what settings do i need to do ?
|
|
|
|
| Re: Creating files in remote directory in UNIX using UTL_FILE [message #42867 is a reply to message #42858] |
Fri, 16 May 2003 06:10  |
Rohit Kanade
Messages: 5
Registered: May 2003
|
Junior Member |
|
|
Do you mean directory on a remote server? You have to follow some steps to actually create a file using UTL_FILE. You can get those steps from PL/SQL sample code from Oracle.com. U have to set the directory and file permissions to 777. ( chmod 777 /dir /dir/fname ).
I've not tried as to how I would transfer the file to remote directory, but I would either use DBLink or rcp that file from a Unix shell script.
|
|
|
|
| Re: Creating files in remote directory in UNIX using UTL_FILE [message #42881 is a reply to message #42867] |
Sat, 17 May 2003 01:48 |
priya
Messages: 108
Registered: February 2000
|
Senior Member |
|
|
Thanks for your response.
Yes,the directory is in a remote server.And I want tro create a file directly on that remote directory.
I know there is a way to create the file locally and ftp to that server.But I am trying to create it directly on that server..
I would appreciate some help on this..
Thanks,
Priya.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
