Skip to Main Content
Forums

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!

Copying file in sub directory using PL SQL

imation3mMay 2 2016 — edited May 3 2016

I have one directory (MPDDIR) on database server on which i am able to store the file generated.

Inside this directory is the backup folder.

I am trying to copy the file to this backup folder with a different name but error ORA-29280: invalid directory path.

UTL_FILE.FCOPY ('MPDDIR',

                     'abc.dat',

                     'MPDDIR/backup',

                     'abc_bkp.dat',

                     1,

                     NULL);

What else is required to be done?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2016
Added on May 2 2016
#oracle
7 comments
2,769 views