I have text file and need to load the data in Oracle through sqlloader.
I need to move this file to unix server and load into oracle. When i SFTP(unfortunately i do not have FTP)
to unix box, each line is appended with ControlM character...
since it is transferring in BINARY format.. I checked the SFTP help.. Here is the help info.
After sftping the text file into unix, here is the file content.
Sqlloader treats ^M as another character and trying to load that charcter...
My sqlloader is failing due to this reason.. How can i handle this situation?
Please let me know if you see any possible solutions...
One option would be to remove this ^M character before we load it. But i don't know how to remove this character...
hi,
I need to sftp a file from one unix system to another unix system.
eg: filename is test.txt
servername : abc@xyz
please give me the sftp command for that.
thanks in advance..
mohan.p (2 Replies)
Hi,
We are facing issue with files transfered using SFTP in Hp-UX.
The transfered files are in Unix Format. That is, file format as UNIX (LF) instead of a PC format (CR & LF).
How can we achieve file transfers as PC format using SFTP?
Your help and input will be highly appreciated.
... (2 Replies)
hi
i am trying to login to remote server using SFTP Protocol and trying to upload a file butit is asking for the password.
Note: I am trying to connect to FrontEnd server
sftp SFTREGUP1@14.71.26.6
Connecting to 14.71.26.6...
Password Authentication
Password:
Please help (14 Replies)
I am having trouble viewing a file in ASCII after doing a 'get' using SFTP. It appears to have come across as machine language. Does the file have to be in ASCII format prior to the 'get' or is there a way to convert it to ascii after I get it onto my server? I have read where the secure file... (0 Replies)
Hi all,
I'm trying to do a script to transfer file between my server and an external server via SFTP protocol. It doesn't use rsa key, but password.
When I run the script, it throw back a prompt that request me to put the password. How should I do for automatic login? Pleaes help :(
... (2 Replies)
Hello all,
I have a requirement, in which we need to stage a package to Unix remote server in an automation (we cant use ssh key generation) , do u have any idea how we can transfer the package to remote server using sftp .if you have any script plz share it to me (4 Replies)
Hi,
I want to a transfer file from remote machine to a local machine using SFTP where both my local and remote machines are Ubuntu machines.So i wanted to write a unix bash script which uses SFTP command to transfer the file from remote to local machine.
My remote server is 178.28.30.106. ... (14 Replies)
Hi guys,
Need a quick and urgent help on below issue.
One of our application is try to transfer the file to another host thru sftp process
My file is about 1 GB.
Job is getting hung while transferring the file. So when I login as sftp and check the file system space is only in MB... (2 Replies)
Hi.
I have managed to transfer a file from remote to my raspberry pi, but I have the camera mounted on the Raspbien so I would like to transfer the image the other way.
I use this line:
sshpass -p 'PASSWORD' scp -- USER@ssh.servername.com:/www/cam/image.jpg /home/pi/shared/web/image.jpg (4 Replies)
Hi All,
Need some help regarding file transfer between server.
Suppose we have system-A and system-B. To transfer file from system-A to system-B we usually share the
public keys of system-A to system-B and do scp/sftp to transfer a file.
Is it possible that public key of system-B can be... (3 Replies)
Discussion started by: abhi_123
3 Replies
LEARN ABOUT DEBIAN
libssh2_sftp_rmdir_ex
libssh2_sftp_rmdir_ex(3) libssh2 manual libssh2_sftp_rmdir_ex(3)NAME
libssh2_sftp_rmdir_ex - remove an SFTP directory
SYNOPSIS
#include <libssh2.h>
#include <libssh2_sftp.h>
int libssh2_sftp_rmdir_ex(LIBSSH2_SFTP *sftp, const char *path,
unsigned int path_len);
DESCRIPTION
Remove a directory from the remote file system.
sftp - SFTP instance as returned by libssh2_sftp_init(3)
sourcefile - Full path of the existing directory to remove.
sourcefile_len - Length of the full path of the existing directory to remove.
RETURN VALUE
Return 0 on success or negative on failure. It returns LIBSSH2_ERROR_EAGAIN when it would otherwise block. While LIBSSH2_ERROR_EAGAIN is a
negative number, it isn't really a failure per se.
ERRORS
LIBSSH2_ERROR_ALLOC - An internal memory allocation call failed.
LIBSSH2_ERROR_SOCKET_SEND - Unable to send data on socket.
LIBSSH2_ERROR_SOCKET_TIMEOUT -
LIBSSH2_ERROR_SFTP_PROTOCOL - An invalid SFTP protocol response was received on the socket, or an SFTP operation caused an errorcode to be
returned by the server.
SEE ALSO libssh2_sftp_init(3)libssh2 0.15 1 Jun 2007 libssh2_sftp_rmdir_ex(3)