Compress/decompress files remotely

[maxsatula]

ocp user/password@connection --gzip DIRECTORY:filename.dmp filename.dmp.zip ocp user/password@connection --gunzip DIRECTORY:filename.dmp.zip filename.dmp

Must be performed via single PL/SQL block, completely on the remote site.

Question: remove an original file after (de-)compression?

Implementation to-do list

• [x] compression itself
• [x] --background option (DBMS_SCHEDULER)
• [ ] accept an extra parameter to specify compressed file name
• [x] remove an original file after (de-)compression
• [ ] remove target file if compression failed

[maxsatula]

Perhaps, this should work via Scheduler Job (always, or with a command line option)