scp in a multi-piped command?

From: Jared (jared_at_hwai.com)
Date: 01/23/04

  • Next message: Darren Dunham: "Re: scp in a multi-piped command?" 
    Date: 23 Jan 2004 13:39:28 -0800

    Hi all,

    I am trying to determine a means of:

    exporting from Oracle |
    passing it through gzip or compress |
    transferring the file |
    gzip -d or uncompress on the other end |
    import into Oracle

    It is very straightforward to take an Oracle export and pipe it to
    'compress'. This works, and is a well-known technique. What I want
    to do is use scp in batch mode for the transfer.

    I have read on how to set up ssh in batch mode and am pretty confident
    I can get it working between two servers. What I am wondering is
    whether anyone here has tried this (or a Sybase bcp) and/or whether
    there is a gotcha I am missing. Comments sought!

    Kind regards,

    Jared

  • Next message: Darren Dunham: "Re: scp in a multi-piped command?"

    Relevant Pages

    • ANNOUNCE: DJGPP port of GNU gzip-1.3.13 uploaded.
      ... This is a port of GNU Gzip 1.3.13 to MSDOS/DJGPP. ... Its main advantages over compress are much better compression ... This port is based on the previous ports gzip13N.zip. ... Windows 9X will produce `foo.tar.gz', ...
      (comp.os.msdos.djgpp)
    • ANNOUNCE: DJGPP port of GNU gzip-1.4 uploaded.
      ... This is a port of GNU Gzip 1.4 to MSDOS/DJGPP. ... Its main advantages over compress are much better compression ... This port is based on the previous ports gzip13N.zip. ... Windows 9X will produce `foo.tar.gz', ...
      (comp.os.msdos.djgpp)
    • Re: NSA and crypto
      ... If you still think gzip is better to use ... You really need a bijective compress so that no information ... no concept of entropy or Unicity Distance. ... Encrypt this with AES using ...
      (sci.crypt)
    • Re: Switching From YUICompressor to Closure Compiler Using ANT
      ... a file is unlikely to make it compress worse. ... DEFLATE algorithm that gzip uses. ... duplicate series of bytes within the sliding window with backreferences ... Removing whitespace in a structured way will not make such encoding ...
      (comp.lang.javascript)
    • Re: gzip is faster with -O3
      ... gzip isn't usually used to compress incompressible data. ... CPU time is better than wallclock time. ...
      (freebsd-stable)