search

maxsatula / ocp

Oracle Copy utility
GNU General Public License v2.0
13 stars 2 forks source link

Verify files after transfer #4

Open maxsatula opened 10 years ago

maxsatula commented 10 years ago

Calculate SHA1 (or MD5?) on both local and remote sites and compare.

maxsatula commented 10 years ago

There is a problem calculating SHA-1 (or any other) hash on Oracle site:

  1. If DBMS_CRYPTO is used, entire file must be placed in some temporary BLOB, consuming TEMP, which is a problem for huge files
  2. If hashing algorithm is implemented in PL/SQL by reinventing the wheel, it will be slow, again being a serious problem for huge files
maxsatula commented 9 years ago

Consider having a stored procedure written in java (similar to --ls implementation). Optionally, --ls command may calculate checksums if provided with --verify option. Can be slow if many large files in a directory.

Note: master branch already uses -c for --continue