Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to convert a database from ZHT16MSWIN950 to UTF8 or AL32UTF8
I tried to use NLS_LANG=american_america.ZHT16MSWIN950 to run
export. While doing import, using ZHT16MSWIN950 will generate no
error, but the data won't be correctly showed in AL32UTF8.
If I use "AL32UTF8" to import to the "AL32UTF8" database, I got these messages
IMP-00019: row rejected due to ORACLE error 1401 IMP-00003: ORACLE error 1401 encountered ORA-01401: inserted value too large for column
"Justin Cave" <jcave_at_ddbcinc.com> 在郵件
news:1096136561.902447.142330_at_k17g2000odb.googlegroups.com 中撰寫...
>
> William wrote:
> > I already used the csscan before I post this question. For
> simulation,
> > I created a database in ZHT16MSWIN950 which has only one user table
> > with one column.
> >
> > No error I can find in the csscan results, that's why the command
> > "convert" can work ( I think this is the reason ).
>
> What are the NLS_LANG settings on the client machine where you are
> running export and import?
>
> Justin Cave <jcave_at_ddbcinc.com>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>
Received on Sun Sep 26 2004 - 03:19:24 CDT