Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE.FRENAME ERROR ORA-29283: invalid file operation

968361Dec 10 2014 — edited Dec 10 2014

Hi ALL,

I have been struggling with this problem for a long time.

When I try to perform an operation to move a file from folder A to folder B. The file moves easily

BEGIN

  UTL_FILE.FRENAME('folder_A',

                     'XYZ.TXT',

                     'folder_B',

                     'XYZ.TXT',

                     FALSE);

                    

END;

But When I try to do the same operation to move the file from

BEGIN

  UTL_FILE.FRENAME('folder_B',

                     'XYZ.TXT',

                     'folder_C',

                     'XYZ.TXT',

                     FALSE);

                    

END;

I am getting error. The dba is saying he has provided all the rights. So i am not sure what wrong I am doing. The error is

ORA-29283: invalid file operation

ORA-06512: at "SYS.UTL_FILE", line 348

ORA-06512: at "SYS.UTL_FILE", line 1290

ORA-06512: at line 2

Can you please suggest some thing.

Regards

-Vinod

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2015
Added on Dec 10 2014
5 comments
2,552 views