Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

COPY_FILE procedure enables you to copy binary files from one location to another

SQL> SQL> CREATE OR REPLACE DIRECTORY source_dir as '/source'; Directory created. SQL> CREATE OR REPLACE DIRECTORY dest_dir as '/dest'; Directory created. SQL> SQL> BEGIN   2       DBMS_FILE_TRANSFER.COPY_FILE(   3       source_directory_object      => 'SOURCE_DIR',   4       source_file_name             => 'test01.dbf',   5       destination_directory_object => 'DEST_DIR',   6       destination_file_name        => 'test_copy.dbf');   7  END;   8       / BEGIN * ERROR at line 1: ORA-19505: failed to identify file "/source\test01.dbf" ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 3) The system cannot find the path specified. ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 84 ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 193 ORA-06512: at line 2