数据文件传输:
    dbms_file_transfer.put_file();
    scp,单机普通文件系统->ASM
    windows->linux
    1.创建共享目录授予读写权限

    1. 源端
    2. mkidr /opt/oracle/backup
    3. create directory mydir as '/opt/oracle/backup';
    4. grant read ,write on directory mydir to public;
    5. 目标端
    6. mkidr /opt/oracle/backup
    7. create directory liunxdir as '/opt/oracle/backup';
    8. grant read ,write on directory liunxdir to public;

    2.创建数据库链接

    1. create public database link orcllink connect to system identified by "Oracle123" using '192.168.5.112:1521/orcl';

    3.调运存储过程传输文件

    1. BEGIN
    2. dbms_file_transfer.put_file(source_directory_object => 'mydir'
    3. ,source_file_name => '08up46d2_1_1'
    4. ,destination_directory_object => 'liunxdir'
    5. ,destination_file_name => '08up46d2_1_1'
    6. ,destination_database => 'orcllink');
    7. END;
    8. /