DBA Tools

SQLULDR2 Bug: ORA-24345 error possible

    It's possible to get ORA-24345 error when you unload data with SQLULDR2, this error is due to no enough memory buffer allocated for column binding, the column data returned exceed the maximum length declared. After a full code...

Posted on June 5, 2009 8:08 AM

Oracle JDBC Asia language support of US7ASCII or WE8ISO8859P1 database

    A lot of earlier created Oracle database did not configure the character set correctly in Asia, they choose US7ASCII, WE8DEC, WE8ISO8859P1 as the database character set. By default they just keep the NLS_LANG the same as database setting,...

Posted on October 19, 2007 8:36 PM

How to change the character set of the export dmp file?

    I saw somebody were asking how to change the character set id in the Oracle export file. I did once in 1998, we had a export file from a US7ASCII database, and wanted to import it into a...

Posted on October 10, 2007 2:40 PM

How does Oracle csscan utility working?

    I create the following table in an UTF8 character set Oracle database. create table t_charset(col1 varchar2(10), col2 varchar2(20));     The I insert two rows under different NLS_LANG settings. The first column is the client NLS_LANG setting, the...

Posted on October 9, 2007 9:40 PM

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