DBMS_FILE_TRANSFER 패키지

DBMS_FILE_TRANSFER Package in Oracle Database 10g

Oracle 10g has introduced the DBMS_FILE_TRANSFER package which provides an API for copying binary files between database servers.

• Common Usage Notes
• COPY_FILE
• GET_FILE
• PUT_FILE

Common Usage Notes

All of the the currently supported procedures have some common usage notes listed below.

• 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.