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

    • 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: gzip is faster with -O3
      ... gzip isn't usually used to compress incompressible data. ... CPU time is better than wallclock time. ...
      (freebsd-stable)
    • Re: compress vs gzip vs bzip2 (vs pack) - was IDS TRIAL ( not trail ) download.
      ... I don't even know if my Linux has an uncompress command, gzip or bunzip2 are the standard. ... It was nowhere near as efficient as compress, which in turn is not as efficient as gzip, which is usually less efficient than bzip2. ...
      (comp.databases.informix)
    • ANNOUNCE: DJGPP port of GNU gzip-1.3.12 uploaded
      ... This is a port of GNU Gzip 1.3.12 to MSDOS/DJGPP. ... DJGPP specific changes. ... Eli Zaretskii's port of GNU Gzip 1.2.4a. ... (if you really mean to compress the text you type from the keyboard). ...
      (comp.os.msdos.djgpp)
    • Re: Compressed Indexes and insert operations
      ... I just moved into this opening and ... and just wanted some validation. ... There is essentially no chance you are ever going to compress all ... Oracle Ace Director & Instructor ...
      (comp.databases.oracle.server)