Database Administration (MOSC)

MOSC Banner

Removing a file remotely using DBlink within PL/SQL

edited Apr 22, 2014 1:33AM in Database Administration (MOSC) 3 commentsAnswered ✓

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',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center