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

• compression itself
• --background option (DBMS_SCHEDULER)
• accept an extra parameter to specify compressed file name
• 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)