COPY_FILE procedure enables you to copy binary files from one location to another : DBMS_FILE_TRANSFER « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_FILE_TRANSFER

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

 

Related examples in the same category