| utl_file.frename error ORA-29283, when renaming to network directory [message #159337] |
Fri, 17 February 2006 07:42  |
liza_bcheri@hotmail.com
Messages: 1
Registered: February 2006
|
Junior Member |
|
|
Hi,
I have a problem when trying to moving a file from one server to another (windows) trough the utl_file.frename.
I works fine when doing it locally from one directory to another directory on same server. But it does not work from one server to another.
In My example below I recreate the file and delete it so the error has nothing to do with file already existing or not existing. It's basically that i cannot access the other server even though i have the directory mapped in the explorer.
Directory I:\4TS\ftp_intrum\to_send is a directoy on the other server.
Here is some more explanation:::
SQL*Plus: Release 9.2.0.1.0 - Production on Fre Feb 17 14:20:13 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Ansluten till:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL> select * From all_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------ -------------------- ------------------------------
SYS DIR_INTRUM_OUT c:\intrumout
SYS DIR_SEND_TO_IJ I:\4TS\ftp_intrum\to_send
SYS DIR_TEST_SEND D:\cbs
SQL> begin
2 utl_file.frename('DIR_INTRUM_OUT', 'test.xml', 'DIR_TEST_SEND', 'test.xml',TRUE);
3 end;
4 /
PL/SQL-procedur õr utf÷rd utan fel.
SQL> begin
2 utl_file.frename('DIR_INTRUM_OUT', 'test.xml', 'DIR_SEND_TO_IJ', 'test.xml',TRUE);
3 end;
4 /
begin
*
Fel pÕ rad 1:
ORA-29292: kunde inte byta namn pÕ filen
ORA-06512: vid "SYS.UTL_FILE", rad 18
ORA-06512: vid "SYS.UTL_FILE", rad 1108
ORA-06512: vid rad 2
SQL>
Br Liza Bcheri
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
