From oracle-l-bounce@freelists.org Fri Mar 18 12:18:02 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2III2jJ009216 for ; Fri, 18 Mar 2005 12:18:02 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2III1em009212 for ; Fri, 18 Mar 2005 12:18:01 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7643C87790; Fri, 18 Mar 2005 12:16:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07800-04; Fri, 18 Mar 2005 12:16:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EBB388778E; Fri, 18 Mar 2005 12:16:18 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=sBZRgVo+q0NZ3dAm8+lqVZXWeI/l6V5mZPBIv/Q8W9NU1NaKRypkc0OiqsW8GdsvC4kVN1ux499Sc0c33w7J4L59QH0c0wdScGdIRdL86CJs3H58VFYUDCYb4d1ZiQAuDFxPLMA0XeQ8lL/9siG+HDIWs28enu92SdOjXxo/yHM= Message-ID: Date: Fri, 18 Mar 2005 09:14:31 -0800 From: Jared Still To: Michael.Kline@suntrust.com Subject: Re: Sftp for transport tablespace Cc: oracle-l@freelists.org In-Reply-To: <52C70FF150F49E479DAF59C68A27149DAFD570@va016a0e2.corp.suntrust.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit References: <52C70FF150F49E479DAF59C68A27149DAFD570@va016a0e2.corp.suntrust.com> X-archive-position: 17464 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Michael, My guess is that you are on a 32 bit system, and the sftp utility cannot handle any file greater than 2 gig. When you get to 2 gig, it is done. Same thing for cp, scp and something else I can't recall. Yes, been there done that. The method I used when trying to overcome the 2 gig limit to copy a file to another machine on the network ( my laptop in this case) was to use netcat. Netcat was started on my laptop listening on a port and redirecting output to a file. Netcat was used on the linux box to send the file to that port on my laptop. I don't recall the exact syntax, but it was fairly simple and easy to figure out after a couple minutes with the man page. You may want to investigate setting up a TCP tunnel with ssh, and then using netcat on top of it, as that would give you the security of sftp. Or not, I haven't actually tried that bit. :) On Tue, 15 Mar 2005 15:52:57 -0500, Kline.Michael wrote: > I'm trying to use sftp for "security" reasons, but I've got some > tablespaces that are quite large, and they are giving me some very > strange errors. The old "bad" ftp routine handles these just perfectly. > The disk being sent to is more than large enough, some 60GB. > > Can't find much on google, but there's talk that if it's a 32-bit module > it may not be able to handle files > 4gb. Still, these are only about > 3GB. > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l