Tips: Add to Google | Oracle DUL? | AUL License | WebChart | asyncdata | ociuldr
Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin
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...
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...
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...
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....
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....
| 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 |