About impdp's doubts
HI,
In my env,Because the Source database's characterset is ZHS16GBK,the Target database's characterset is AL32UTF8,So when I perform impdp on the Target database,it report errors,i.e.:
ORA-02374: conversion error loading table "DCP_IMP"."XQ_JG_BJXX_20130113"
ORA-12899: value too large for column TBR (actual: 39, maximum: 36)
ORA-02372: data for row: TBR : 0X'C6EBC6EBB9FEB6FBCAD0CCFAB7E6C7F8D3CAD5FED3D7B6F9D4'
Now,I have a resolution that impdp the metadata into to Target database at first,and then modify the column size that occur erros. Finaly, I impdp the data_only into the Target database.
In my env,Because the Source database's characterset is ZHS16GBK,the Target database's characterset is AL32UTF8,So when I perform impdp on the Target database,it report errors,i.e.:
ORA-02374: conversion error loading table "DCP_IMP"."XQ_JG_BJXX_20130113"
ORA-12899: value too large for column TBR (actual: 39, maximum: 36)
ORA-02372: data for row: TBR : 0X'C6EBC6EBB9FEB6FBCAD0CCFAB7E6C7F8D3CAD5FED3D7B6F9D4'
Now,I have a resolution that impdp the metadata into to Target database at first,and then modify the column size that occur erros. Finaly, I impdp the data_only into the Target database.
0