Navigation
 
ubSQL

  • ubSQL is a utiliy which unloads Oracle data to text format; runs DML/DDL statements.
ubTools Suite 4.0.0 is available



July 03, 2011
ubTools Suite 4.0.0 is available. New features:

Why ubSQL

 

  •  Fast
    • C-based utiliy.
    • Multi-threaded utility. N threads fetch data; N threads process fetched data; N threads write processed data to disks.
    • Uses Oracle Call Interface (OCI), which is the lowest documented layer to access Oracle.
    • Uses Operating System Kernel Calls directly in many unload operations without needing a library overhead.
    • Multiple sessions can unload different parts of a table at the same time.
    • Oracle data can be unloaded to multiple output files.
    • Array Fetching is used in unload operations.
    • Bypasses Operating System Filesystem Cache in Linux platforms.
  • Generating SQL*Loader control file
  • Generating External Table creation and loading script
  • Unloading in TEXT and External Table BINARY format
  • Unloading into REGULAR and NAMED PIPES