Removing a file remotely using DBlink within PL/SQL
Greetings -
I want to remove a file on a remote server accessed by a database link. - Basically, I want to remove this file remotely using DBlink within PL/SQL..
FYI - I was able to transfer the file [ HR_FILE.dmp ] remotely successfully using the the Proc below. But now, I need to remove the same file. Could someone provide the syntax to remove the file remotely using DBlink please.. My DB ver: 11.2.0.4
BEGIN
DBMS_FILE_TRANSFER.PUT_FILE(
source_directory_object => 'DATA_PUMP_DIR',
source_file_name => 'HR_FILE.dmp',
destination_directory_object => 'DATA_PUMP_DIR',
destination_file_name => 'HR_FILE.dmp',