Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sftp for transport tablespace

RE: Sftp for transport tablespace

From: Mohan, Ross <RMohan_at_arbinet.com>
Date: Fri, 18 Mar 2005 20:46:49 -0000
Message-ID: <CC74E7E10A8A054798B6611BD1FEF4D3079669E3@vamail01.thexchange.com>


cudnja also dd to cross-machine pipe?

probably another clue-free shot from hip....

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Friday, March 18, 2005 12:15 PM
To: Michael.Kline_at_suntrust.com
Cc: oracle-l_at_freelists.org
Subject: Re: Sftp for transport tablespace

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 = <Michael.Kline_at_suntrust.com> wrote:
> I'm trying to use sftp for "security" reasons, but I've got some=20
> tablespaces that are quite large, and they are giving me some very=20
> strange errors. The old "bad" ftp routine handles these just=20
> perfectly. The disk being sent to is more than large enough, some=20
> 60GB.

>=20

> Can't find much on google, but there's talk that if it's a 32-bit=20
> module it may not be able to handle files > 4gb. Still, these are only =

> about 3GB.

>=20

--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 18 2005 - 15:50:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US