How to fix the Oracle error LFI-00122: Can only delete a file if we create it.?

In this post, you’ll learn more about the Oracle ErrorLFI-00122: Can only delete a file if we create it. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

LFI-00122: Can only delete a file if we create it.

Reason for the Error LFI-00122: Can only delete a file if we create it.

The delete file flag was specified for a file that was not created by this file operation. The ability to delete a file is not portable. As such the only deletion that is allowed by this package is if we know we want to delete the file when we create it.

How to fix the Error LFI-00122: Can only delete a file if we create it. ?

You can fix this error in Oracle by following the below steps

You can only delete a file that you create. If you need to delete a file that you do not create then you will have to find another means of doing so.