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

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

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