Tips: Add to Google | Oracle DUL? | AUL License | AnySQL.net | asyncdata | ociuldr
Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin
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...
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....
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...
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...
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:...
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....
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...
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,...
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 ...
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...
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...
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...
| Name | Fangxin Lou |
| Job | Oracle DBA |
| Loc | Shanghai China (+08:00) |
| Skype | anysql |
| MSN | anysql©live.com |
| AIM | loufangxin |
| anysql©126.com anysql©yahoo.com |