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!

Deleting OS files using UTL_FILE package

636674Aug 8 2008 — edited Aug 11 2008

Hi,

I have an oracle directory object defined on an operating system folder. This directory gets an archive file(.arc generated by bespoke application) every 10 seconds with a time-stamp in the file name by an oracle job. I want to regularly delete old archive files from this directory. I have tried this using UTL_FILE package, but it deletes one file at time. I am wondering is there any other way to delete files in bulk?

Any suggestions would be highly appreciated.

Regards,

Aniket Shetye

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2008

Added on Aug 8 2008

6 comments

1,255 views