DBMS FILE TRANSFER
From Oracle FAQ
DBMS_FILE_TRANSFER is a PL/SQL package for transferring database files between databases (possibly on different systems) and between ASM and non-ASM storage. This package can also be used to instantiate Data Guard databases.
CREATE DIRECTORY source_dir AS ‘/u01/oradata/orcl/’; CREATE DIRECTORY dest_dir AS ‘/u01/oradata/db2/’; BEGIN DBMS_FILE_TRANSFER.COPY_FILE( source_directory_object => ‘SOURCE_DIR’, source_file_name => ‘data01.ora’, destination_directory_object => ‘DEST_DIR’, destination_file_name => ‘data01.ora’); END; /