附:DBMS_FILE_TRANSFER使用限制
# The user must have read privilege on the source directory object and write privilege on the destination directory object.
# The procedure converts directory object names to uppercase unless they are surrounded by double quotes.
# Files to be copied must be multiples of 512 bytes in size.
# Files to be copied must be equal to or less than 2 terabytes in size.
# File transfers are not transactional.
# Files are copied as binary, so no character conversions are performed.
# File copies can be monitored using the V$SESSION_LONGOPS view
++++++++++++++++++++++++++
据一同事反映,Oracle 11g提供了ASM cp命令,允许在ASM磁盘组和操作系统文件之间互相拷贝。详见metalink doc 785580.1 451900.1