Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

September 2, 2007

Announcement of a new product; ubSQL from ubTools

Filed under: Oracle Best Practices,Oracle Business Intelligence,Oracle Other — H.Tonguç Yılmaz @ 9:36 am

ubSQL is a utility which unloads Oracle data to text format; runs DML/DDL statements. So why ubSQL ?

  • It is a fast, C-based utility.
  • 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.
  • Creating SQL*Loader control file is possible.
  • Regular and Named Pipes are supported as Output File Types.
  • Reading Oracle data directly from disks without using Oracle SGA is currently under development.
  • Supported Oracle Versions Oracle 9i and onwards are supported.

ubSQL Presentation

ps: itrprof SQL Analyzer

1 Comment »

  1. […] and RSS Filed under: Oracle How To — H.Tonguç Yılmaz @ 3:59 pm Recently I posted the Announcement of ubSQL from ubTools. And here are the ubTools Support IssueNavigator and ubTools Support RSS. I guess you will like […]

    Pingback by ubTools Support IssueNavigator and RSS « H.Tonguç YILMAZ Oracle Blog — September 15, 2007 @ 3:59 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: