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
