Home » Other » Marketplace » Transport utility (11g and higher, Unix or Windows)
Transport utility [message #676271] Fri, 24 May 2019 02:53
Olexandr Siroklyn
Messages: 36
Registered: September 2018
Location: USA

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.


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.


Simplified BSD license

Downloads and feedbacks are very appreciated and highly welcome.

[Updated on: Fri, 24 May 2019 02:54]

Report message to a moderator

Previous Topic: What Tool is used for Oracle Database to MySQL Migration
Next Topic: Public key encryption tool
Goto Forum:

Current Time: Wed May 22 00:10:58 CDT 2024