Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DBMS_FILE_TRANSFER.get_file(
- source_directory_object => 'db1_dir',
- source_file_name => 'test.html',
- source_database => 'db2_to_db1',
- destination_directory_object => 'db2_dir',
- destination_file_name => 'test.html');
- END;
- /
- DBMS_FILE_TRANSFER.put_file(
- source_directory_object => 'db1_dir',
- source_file_name => 'test.html',
- destination_directory_object => 'db2_dir',
- destination_file_name => 'test.html');
- destination_database => 'db1_to_db2',
- END;
- /
- ORA-19505: failed to identify file "/rdsdbdata/userdirs/05/test.html"
- ORA-27046: file size is not a multiple of logical block size
- Additional information: 1
- ORA-02063: preceding 3 lines from db1_to_db2/db2_to_db1
- ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 37
- ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 132
- ORA-06512: at line 2
- 19505. 00000 - "failed to identify file "%s""
- *Cause: call to identify the file returned an error
- *Action: check additional messages, and check if the file exists.
Add Comment
Please, Sign In to add comment