মঙ্গলবার, ১১ আগস্ট, ২০২০

File Transfer Using Oracle

 DBMS_FILE_TRANSFER.COPY_FILE(
   source_directory_object       IN  VARCHAR2,
   source_file_name              IN  VARCHAR2,
   destination_directory_object  IN  VARCHAR2,
   destination_file_name         IN  VARCHAR2);


BEGIN
DBMS_FILE_TRANSFER.COPY_FILE('DMPDIR',"expdp_28-07-Tue_23.00_PM.zip", 'DMPDIR',
                                   "expdp_28-07-Tue_23.00_PM2.zip");
END;

create or replace directory DMPDIR AS 'G:\';

create or replace directory DMPDIR2 AS 'G:\NEW';


BEGIN
  DBMS_FILE_TRANSFER.COPY_FILE(
   source_directory_object      => 'DMPDIR',
   source_file_name             => 'IMPORT.LOG',
   destination_directory_object => 'DMPDIR',
   destination_file_name        => 'IMPORT2.LOG');
END;
/


begin
UTL_FILE.FCOPY ('DMPDIR', 'expdp_28-07-Tue_23.00_PM.zip', 'DMPDIR', 'expdp_28-07-Tue_23.00_PM2.zip');
end;
/