Transport utility [message #676271] |
Fri, 24 May 2019 02:53 |
![](http://www.gravatar.com/avatar/ad337c91e3c1f6cc2430faa021867dcf?s=64&d=mm&r=g) |
Olexandr Siroklyn
Messages: 41 Registered: September 2018 Location: USA
|
Member |
|
|
http://www.oracleongpu.com/fcbtrans/
FCBTrans utility provides possibility to transfer binary or text files via Oracle software stack only, i.e. SQL*Plus utility and Oracle database. It could be useful if you need to provide to the customers launch of Oracle impdp utility, for example, but you don't want to set up customer access to the database host via ssh, scp, ftp or stuff like that.
How it works
File to upload is encoded to the base64 format. Encoded file is splitted on 32K chunks. Every chunk is pasted into anonymous PL/SQL block. SQL*Plus starts, connects to the database and executes anonymous PL/SQL block. Anonymous PL/SQL block calls server PL/SQL stored procedure and passes chunk. Stored procedure write chunk to the output file in append mode via UTL_FILE package. Output file is placed at the directory previously chosen from DBA_DIRECTORIES view. Output file is decoded from base64 format.
Operating system support
All major Unixes, i.e. Linux, SUN/Oracle Solaris, IBM AIX. Most probably software works on HP-UX and Windows, but it wasn't tested.
Database support
Oracle 11g, 12c, 18c ,19c. Express, Standard or Enterprise editions. On-premises or cloud based.
Security
FCBTrans software doesn't use any encryption during file transfer. But you can configure
data encryption and integrity via standard Oracle way, i.e. server side sqlnet.ora file.
License
Simplified BSD license
Downloads and feedbacks are very appreciated and highly welcome.
Thanks.
[Updated on: Fri, 24 May 2019 02:54] Report message to a moderator
|
|
|