DBMS FILE TRANSFER

From Oracle FAQ
Jump to: navigation, search

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.

[edit] Example

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;
/