Guest User

Untitled

a guest
Jan 17th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. DBMS_FILE_TRANSFER.get_file(
  2. source_directory_object => 'db1_dir',
  3. source_file_name => 'test.html',
  4. source_database => 'db2_to_db1',
  5. destination_directory_object => 'db2_dir',
  6. destination_file_name => 'test.html');
  7. END;
  8. /
  9.  
  10. DBMS_FILE_TRANSFER.put_file(
  11. source_directory_object => 'db1_dir',
  12. source_file_name => 'test.html',
  13. destination_directory_object => 'db2_dir',
  14. destination_file_name => 'test.html');
  15. destination_database => 'db1_to_db2',
  16. END;
  17. /
  18.  
  19. ORA-19505: failed to identify file "/rdsdbdata/userdirs/05/test.html"
  20. ORA-27046: file size is not a multiple of logical block size
  21. Additional information: 1
  22. ORA-02063: preceding 3 lines from db1_to_db2/db2_to_db1
  23. ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 37
  24. ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 132
  25. ORA-06512: at line 2
  26. 19505. 00000 - "failed to identify file "%s""
  27. *Cause: call to identify the file returned an error
  28. *Action: check additional messages, and check if the file exists.
Add Comment
Please, Sign In to add comment