数据文件传输:
dbms_file_transfer.put_file();
scp,单机普通文件系统->ASM
windows->linux
1.创建共享目录授予读写权限
源端mkidr /opt/oracle/backupcreate directory mydir as '/opt/oracle/backup';grant read ,write on directory mydir to public;目标端mkidr /opt/oracle/backupcreate directory liunxdir as '/opt/oracle/backup';grant read ,write on directory liunxdir to public;
2.创建数据库链接
create public database link orcllink connect to system identified by "Oracle123" using '192.168.5.112:1521/orcl';
3.调运存储过程传输文件
BEGINdbms_file_transfer.put_file(source_directory_object => 'mydir',source_file_name => '08up46d2_1_1',destination_directory_object => 'liunxdir',destination_file_name => '08up46d2_1_1',destination_database => 'orcllink');END;/
