DBMS_FILE_TRANSFER用法取asm下文件

###192.168.8.115的asm里下的日志文件取到192.168.8.116所在的asm或者os下###
DBMS_FILE_TRANSFER包提供几种方法在数据库间复制和传输二进制文件

--在116上创建database linkcreate public database link dblk_115 connect to t_dblk identified by t_dblk using t_dblk;create user t_dblk identified by t_dblk account unlock;grant dba to t_dblk;--载115创建源目录CREATE OR REPLACE DIRECTORY test1 AS '+flashare_dg/orcl/archivelog/2014_01_03' ;GRANT WRITE ON DIRECTORY test1 TO t_dblk;--在116创建目标目录CREATE DIRECTORY test3 AS '/u01/test2';GRANT WRITE ON DIRECTORY test2 TO sys;--利用dbms_file_transfer工具指定传输beginDBMS_FILE_TRANSFER.GET_FILE(source_directory_object=>'test1',source_file_name=>'thread_1_seq_152.305.835872239',source_database=>'dblk_115',destination_directory_object=>'test3',destination_file_name=>'thread2');end;--传输后在192.168.8.116asm上及OS上的结果ASMCMD> lsthread1thread2ASMCMD> ls -slType        Redund  Striped  Time             Sys  Block_Size  Blocks     Bytes     Space  Name                                              N                                            thread1 => +DATA_DG1/TRSEN/ARCHIVELOG/FILE_TRANSFER/thread_0_seq_0.256.835886497                                              N                                            thread2 => +DATA_DG1/TRSEN/ARCHIVELOG/FILE_TRANSFER/thread_0_seq_0.257.835886791ASMCMD> cd +data_dg1/trsen/archivelog/file_transfer/ASMCMD> ls -slType        Redund  Striped  Time             Sys  Block_Size  Blocks     Bytes     Space  NameARCHIVELOG  UNPROT  COARSE   JAN 03 14:00:00  Y           512  100057  51229184  51380224  thread_0_seq_0.256.835886497ARCHIVELOG  UNPROT  COARSE   JAN 03 14:00:00  Y           512  100057  51229184  51380224  thread_0_seq_0.257.835886791--OS上[oracle@trsen test2]$ pwd/u01/test2[oracle@trsen test2]$ lltotal 50088-rw-r----- 1 oracle oinstall 51229184 Jan  3 14:52 thread2--查询删除，删除相关数据及目录select object_name from dba_objects where object_type='DATABASE LINK';drop directory test3 ;drop directory test1 ;drop user t_dblk cascade;drop public database link dblk_115；