Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Verify files after transfer #4

Open
maxsatula opened this issue Jul 2, 2014 · 2 comments
Open

Verify files after transfer #4

maxsatula opened this issue Jul 2, 2014 · 2 comments
Labels
enhancement

Comments

@maxsatula
Copy link
Owner

Calculate SHA1 (or MD5?) on both local and remote sites and compare.
@maxsatula
Copy link
Owner Author

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 added a commit that referenced this issue Sep 23, 2014
@maxsatula
Added [-c|--verify] option to verify files by CRC32 after transfer
5ed401e 
Related to #4
This is not a solution yet because is extremely slow, PL/SQL implementation of CRC32 processes ~2 megabytes per minute (!)
@maxsatula
Copy link
Owner Author

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

maxsatula added a commit that referenced this issue Mar 31, 2016
@maxsatula
Add ability to calculate MD5 or SHA1 digests in --ls
3ddab89 
Relates to #4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@maxsatula