DBA Tools

New command line option for text export utility -- BUFFER

    When tuning the performance of Oracle SQL loader (sqlldr), the read size and bind size option are very critical. When ociuldr utility generate the SQL loader control file for you, the default read size and bind size are...

Posted on October 11, 2007 9:31 PM

Choosing right separators when unload (export) rows to text file

    I am moving some data by ociuldr with the following field and record option. ociuldr ... field=0x07 record=0x06 ...     I think it will work well, but actually not, there are rows rejected when loading with sqlldr....

Posted on September 27, 2007 4:13 PM

The LONG RAW data type support of text unload (export) utility

    Now you can use ociuldr to move data with LONG RAW type. Just the same as LONG type, the "long=" option define the maximum length ociuldr will read. You may need to set the proper value of this...

Posted on September 26, 2007 2:23 PM

What does the REPLACE mode of Oracle SQL Loader do?

    There is something wrong in my mind about the "REPLACE" mode of Oracle SQL Loader, I have thought that sqlldr will use a merge logic, to replace matched rows if the target table has a primary key. But...

Posted on September 25, 2007 3:22 PM

Make some changes to the text unload utility -- ociuldr

    I made few changes to this free utility, a new option "mode=" is introduced to change the load mode, there are four different modes in sqlldr. INSERT: Load data into empty table, this is the default mode. APPEND:...

Posted on September 20, 2007 10:48 AM

Migrate data from US7ASCII database to UTF8 database

    Some old databases are created with US7ASCII character set, when the client NLS_LANG setting was the same with database character set, Oracle will not do any conversion, so the client was able to store Chinese into the database....

Posted on September 19, 2007 11:33 PM

Load sybase date type into Oracle -- sqlldr

    I get this question from oracle-l groups about how to put "Sep 17 2007  7:00:00:020AM" (values from Sybase database) into an Oracle date column.. After several retries, I am be able to load it now. I create a...

Posted on September 18, 2007 7:53 PM

sqlldr - Internal error: ulconnect: OCIInitialize [1804]

    One of our batch job get the following error when calling sqlldr to load text file into database. % 9205/bin/sqlldr *****/*****@***** control=testsqlldr.ctl data=..... SQL*Loader: Release 9.2.0.5.0 - Production on Tue Aug 7 18:00:35 2007 Copyright (c) 1982, 2002,...

Posted on September 17, 2007 6:11 PM

High performance tuning for Oracle SQL Loader

    To get the maximum performance of Oracle SQL Loader (sqlldr), take the following into account.     Use fixed width column text file such as following. 10 ACCOUNTING   NEW YORK 20 RESEARCH     DALLAS 30 SALES        CHICAGO 40 OPERATIONS   BOSTON      ...

Posted on September 15, 2007 5:19 PM

How to upload OS files to LOB columns with Oracle SQL Loader

    By DBMS_LOB PL/SQL package I cannot load client OS files to LOB columns, you can either use lobs utility, or use Oracle's SQL Loader (sqlldr) to do this job.     I have the following OS files in...

Posted on September 13, 2007 11:37 AM

Generate SQL Loader control file when unloading with ociuldr

    Oracle's SQL Loader (sqlldr) can be used to load rows in text file into database tables. But sqlldr need a control file to specify how to interpret the text file format, including the column (field) separator, the record...

Posted on September 12, 2007 2:21 PM

How to unload or export rows as text file, excel CSV file, or excel xls file?

    When export oracle data to different database platform, text file is always a good choice and may be the only choice, if they cannot connect directly. And some time I was required to provide some rows in excel...

Posted on September 7, 2007 9:27 PM