This procedure removes the specified file from the specified directory on Autonomous Database.
DBMS_CLOUD.DELETE_FILE( directory_name IN VARCHAR2, file_name IN VARCHAR2);
The name of the directory on the Autonomous Database instance.
The name of the file to be removed.
DBMS_CLOUD.DELETE_FILEwith a user other than ADMIN you need to grant write privileges on the directory that contains the file to that user. For example, run the following command as ADMIN to grant write privileges to
GRANT WRITE ON DIRECTORY data_pump_dir TO atpc_user;