数据文件传输:
dbms_file_transfer.put_file();
scp,单机普通文件系统->ASM
windows->linux
1.创建共享目录授予读写权限
源端
mkidr /opt/oracle/backup
create directory mydir as '/opt/oracle/backup';
grant read ,write on directory mydir to public;
目标端
mkidr /opt/oracle/backup
create 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.调运存储过程传输文件
BEGIN
dbms_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;
/