UTL_FILE RENAME FUNCTION [message #41196] |
Mon, 09 December 2002 15:14 |
Das
Messages: 92 Registered: November 2002
|
Member |
|
|
Hi all,
I am trying to use the New Rename capability of the UTL File(Oracle 9.2.0.1.0). But I am getting an error saying:
ORA-29292: file rename operation failed
I checked the error details and I am not breaking any rules, like I have the right directory names, I have permissions on the Directories and there are no files with the same names, So I guess I am missing some point somewhere, If anyone has had a similar problem please let me know.
Here are my parameters
UTL_FILE.FRENAME ('c:test', 'Test.txt', 'c:testnew', 'test2.txt', true);
Thanks
Das
|
|
|
|
Re: UTL_FILE RENAME FUNCTION [message #41215 is a reply to message #41196] |
Tue, 10 December 2002 06:42 |
Rick Cale
Messages: 111 Registered: February 2002
|
Senior Member |
|
|
I do not think it matters what privs you have but what the owner of the oracle process has. For ex. in NT
the service maybe started under a specified user who does not have privs to rename. I guess rename requires
delete and create. Check privs of owner of oracle process.
Rick
|
|
|