DBA Tools

Data Migration between different Oracle character set

    Supposed that we have few handerds of data stored in US7ASCII database, and we need to switch the system to an UTF8 database, how could we get the system switched in just few minutes without long period outage...

Posted on April 14, 2010 12:35 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

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

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