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 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)
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 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 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)
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 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)
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
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)
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 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)