10 Replies Latest reply: Mar 22, 2013 12:09 AM by TSharma-Oracle RSS

    Clarification regarding Rename of file in database directory

    MST
      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.