Hello -
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.
Unfortunately not.
Until recently, this was a limitation of the file transfer protocols: the SCP and SFTP
protocols had no notion of transferring a file in anything
other than binary mode. (This is still true of SCP.)
The current draft protocol spec of SFTP proposes a means of implementing ASCII transfer.
At some point PSCP/PSFTP may implement
this proposal.
After sftping the text file into unix, here is the file content.
F2|Invoice||x^M
F2B|Nota fiscal||x^M
G2|Credit Memo|x|x^M
G2B|Credit memo BR|x|x^M
L2|Debit Memo||x^M
L2B|Debit memo BR||x^M
RE|Credit for Returns|x|x^M
REB|Ret. credit memo BR|x|x^M
S1|Cancel. Invoice (S1)|x|x^M
S2|Cancel of Cred Memo||x^M
WIA|Plants Abroad||x^M
Z2|Revenue Recong.Billi||x^M
ZFVB|BR Contract Invoice||x^M
ZFVI|Invoice Contract||x^M
ZL2|Debit Memo||x^M
ZL3|Debit Memo Deposit||x^M
ZL4|Credit Memo Deposit|x|x^M
ZFIN|MAC Order ||X^M
ZMSV| Monthly Maintenance Invoice||X^M
ZREY| Avaya Install Rev Recognition (no customers)||X^M
ZTMI| T&M or Term Fees||X^M
ZVMI| Managed Services Mac Order||X^M
ZVSV|Managed Services Maintenance ||X^M
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...
Any help please....