This discussion is archived
10 Replies Latest reply: Mar 21, 2013 10:09 PM by TSharma-Oracle RSS

Clarification regarding Rename of file in database directory

MST Newbie
Currently Being Moderated
Hi,

My databaser version : Oracle 8i
MAIL_OUTPUT is database directory.

When i rename text file then file renaming sucessfully.
-----------------
begin
utl_file.frename('MAIL_OUTPUT','TEST.txt', 'MAIL_OUTPUT','TEST123.txt',TRUE);
END;
/

PL/SQL procedure successfully completed.
----------------

When i rename XML file then below error coming:

--------------------
Satish>begin
2 utl_file.frename('MAIL_OUTPUT','TEST.xml', 'MAIL_OUTPUT','TEST123.xml',TRUE);
3 end;
4 /
begin
*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 1108
ORA-06512: at line 2
---------------------

Please do the needful.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points