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 MOJAVE
curlopt_ftp_create_missing_dirs
CURLOPT_FTP_CREATE_MISSING_DIRS(3) curl_easy_setopt options CURLOPT_FTP_CREATE_MISSING_DIRS(3)NAME
CURLOPT_FTP_CREATE_MISSING_DIRS - create missing dirs for FTP and SFTP
SYNOPSIS
#include <curl/curl.h>
typedef enum {
CURLFTP_CREATE_DIR_NONE,
CURLFTP_CREATE_DIR,
CURLFTP_CREATE_DIR_RETRY
} curl_ftpcreatedir;
CURLcode curl_easy_setopt(CURL *handle, CURLOPT_FTP_CREATE_MISSING_DIRS,
long create);
DESCRIPTION
Pass a long telling libcurl to create the dir. If the value is CURLFTP_CREATE_DIR (1), libcurl will attempt to create any remote directory
that it fails to "move" into.
For FTP requests, that means a CWD command fails. CWD being the command that changes working directory.
For SFTP requests, libcurl will attempt to create the remote directory if it can't obtain a handle to the target-location. The creation
will fail if a file of the same name as the directory to create already exists or lack of permissions prevents creation.
Setting create to CURLFTP_CREATE_DIR_RETRY (2), tells libcurl to retry the CWD command again if the subsequent MKD command fails. This is
especially useful if you're doing many simultaneous connections against the same server and they all have this option enabled, as then CWD
may first fail but then another connection does MKD before this connection and thus MKD fails but trying CWD works!
DEFAULT
CURLFTP_CREATE_DIR_NONE (0)
PROTOCOLS
FTP and SFTP
EXAMPLE
TODO
AVAILABILITY
Added in 7.10.7. SFTP support added in 7.16.3. The retry option was added in 7.19.4.
RETURN VALUE
Returns CURLE_OK if the option is supported, and CURLE_UNKNOWN_OPTION if the create value is not.
SEE ALSO CURLOPT_FTP_FILEMETHOD(3), CURLOPT_FTP_USE_EPSV(3),
libcurl 7.54.0 February 03, 2016 CURLOPT_FTP_CREATE_MISSING_DIRS(3)