oracle 10g database character set issue

[rpoduval]

I have a 10g TARGET database with a single byte character set of western european and 9i SOURCE databse with multibyte character of UTF8 since the character sets are different to load data from 9i to 10g I am using national character set NCHAR columns on target database to store the multi byte data :

this is the table i am working on loading

CREATE TABLE RAN_TEST1_MDL
( MODEL_ID NUMBER(15) NOT NULL,
PRODUCT_ID NUMBER(15) NULL,
MODEL_CODE NVARCHAR2(540) NULL,
ODM_CODE NVARCHAR2(900) NULL,
MODEL_DESC NVARCHAR2(1200) NULL )
tablespace csn_d_01 LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING
/

The table is test table on oracle 10g database .
This is the query I am running

INSERT /*+append*/ INTO WORK_HIER_MDL(
MODEL_ID,
PRODUCT_ID,
MODEL_CODE,
ODM_CODE,
MODEL_DESC
)
SELECT
MODEL_ID,
PRODUCT_ID,
MODEL_CODE,
ODM_CODE,
MODEL_DESC
FROM SHLD_HIER_MDL

shld_hier_mdl is source table from oracle 9i multi byte UTF8 database.
WORK_HIER_MDL is target table on oracle 10g single byte western european databse

Error : ORA-29275: partial multibyte character

When I describe the source table SHLD_HIER_MDL ( on 9i oracle accesed thru a db link ) I get the following error

ORA-01460: unimplemented or unreasonable conversion requested


I think ORA-29275 and ORA-01460 are correleted . Can anyone suggest what could be the cause for this ? Thanks

 

[dbtoo2001]

Maybe you need to do a conversion from the source:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions187.htm#SQLRF06136

INSERT /*+append*/ INTO WORK_HIER_MDL(
MODEL_ID,
PRODUCT_ID,
MODEL_CODE,
ODM_CODE,
MODEL_DESC
)
SELECT
MODEL_ID,
PRODUCT_ID,
TO_NCHAR(MODEL_CODE),
TO_NCHAR(ODM_CODE),
TO_NCHAR(MODEL_DESC)
FROM SHLD_HIER_MDL