Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sftp for transport tablespace
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
> 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-lReceived on Fri Mar 18 2005 - 15:50:35 CST