导入数据报IMP-00041
报错信息如下:
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "MAXIMO"."V_ASSETPD_CY" ("PCRNUM"
"","AS_NUM","AS_ITEMNUM","AS_NAME","AS_TYPE","AS_SRC","AS_STATE","AS_RESPONS"
"E","LOCATION","AS_RESPONSEDEPT","AS_NUMBER","LX") AS "
"select pcrnum,as_num,as_itemnum,AS_NAME,AS_TYPE,AS_SRC,AS_STATE,AS_RESPONSE"
",LOCATION,AS_RESPONSEDEPT,AS_NUMBER,-1 as lx"
"from asset_pdlist a where not exists(select 1 from asset_pdimport b where "
"b.as_num=a.as_num and b.as_itemnum=a.as_itemnum and b.pcrnum=a.pcrnum)"
"union all"
"select pcrnum,as_num,as_itemnum,AS_NAME,AS_TYPE,AS_SRC,AS_STATE,AS_RESPONSE"
",LOCATION,AS_RESPONSEDEPT,AS_NUMBER,1 as lx"
"from asset_pdimport a where not exists(select 1 from asset_pdlist b where b"
".as_num=a.as_num and b.as_itemnum=a.as_itemnum and b.pcrnum=a.pcrnum )"
"union all"
"select b.pcrnum,b.as_num,b.as_itemnum,b.AS_NAME,b.AS_TYPE,b.AS_SRC,b.AS_STA"
"TE,b.AS_RESPONSE,b.LOCATION,b.AS_RESPONSEDEPT,b.AS_NUMBER,0 as lx"
"from asset_pdimport a, asset_pdlist b where b.as_num=a.as_num and b.as_item"
"num=a.as_itemnum and b.pcrnum=a.pcrnum"
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "MAXIMO"."V_WO_CZP" ("SHEETID",""
"SHEETNAME","DRAFTNAME","MAKETIME","WONUM","WODESC","TAGOUTDESC") AS "
"select sheet.sheetid, sheet.sheetname, sheet.draftname, sheet.maketime,"
" wo.wonum, wo.description wodesc, wl.devicedescription tagoutdesc"
" from workorder wo, wolockout wl, wotaglock wt, V_WO_REPORT worpt, ws_sheet"
"index@czp_link sheet"
" where sheet.wonum > ' ' and sheet.sheettype in (1,7,8) and"
" sheet.wonum like '%'||wo.wonum||'%' and wo.wonum = worpt.wonum and"
" wo.wonum = wt.wonum and wo.wonum = wl.wonum and"
" wt.lockoutid = wl.lockoutid and wo.statusdate > sysdate - 365 and"
" wt.tagoutid not like 'JX%' and wl.devicedescription <> '?' and"
" wt.tagoutid <> '????' and wt.tagoutid <> '000THP002'"
About to enable constraints...
Import terminated successfully with warnings.
查询表发现有乱码,但是英文字符没任何问题,就是中文是乱码
SQL> select * from nls_database_parameters;
使用这个命令查看语言是都是NLS_CHARACTERSET
ZHS16GBK
导出系统是HP-UNIX 导入的系统为AIX 导出过程为:在HP服务器上导出,然后使用BIN传到IBM服务器上,不知道具体问题处在哪里?请高手指点 谢谢
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "MAXIMO"."V_ASSETPD_CY" ("PCRNUM"
"","AS_NUM","AS_ITEMNUM","AS_NAME","AS_TYPE","AS_SRC","AS_STATE","AS_RESPONS"
"E","LOCATION","AS_RESPONSEDEPT","AS_NUMBER","LX") AS "
"select pcrnum,as_num,as_itemnum,AS_NAME,AS_TYPE,AS_SRC,AS_STATE,AS_RESPONSE"
",LOCATION,AS_RESPONSEDEPT,AS_NUMBER,-1 as lx"
"from asset_pdlist a where not exists(select 1 from asset_pdimport b where "
"b.as_num=a.as_num and b.as_itemnum=a.as_itemnum and b.pcrnum=a.pcrnum)"
"union all"
"select pcrnum,as_num,as_itemnum,AS_NAME,AS_TYPE,AS_SRC,AS_STATE,AS_RESPONSE"
",LOCATION,AS_RESPONSEDEPT,AS_NUMBER,1 as lx"
"from asset_pdimport a where not exists(select 1 from asset_pdlist b where b"
".as_num=a.as_num and b.as_itemnum=a.as_itemnum and b.pcrnum=a.pcrnum )"
"union all"
"select b.pcrnum,b.as_num,b.as_itemnum,b.AS_NAME,b.AS_TYPE,b.AS_SRC,b.AS_STA"
"TE,b.AS_RESPONSE,b.LOCATION,b.AS_RESPONSEDEPT,b.AS_NUMBER,0 as lx"
"from asset_pdimport a, asset_pdlist b where b.as_num=a.as_num and b.as_item"
"num=a.as_itemnum and b.pcrnum=a.pcrnum"
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "MAXIMO"."V_WO_CZP" ("SHEETID",""
"SHEETNAME","DRAFTNAME","MAKETIME","WONUM","WODESC","TAGOUTDESC") AS "
"select sheet.sheetid, sheet.sheetname, sheet.draftname, sheet.maketime,"
" wo.wonum, wo.description wodesc, wl.devicedescription tagoutdesc"
" from workorder wo, wolockout wl, wotaglock wt, V_WO_REPORT worpt, ws_sheet"
"index@czp_link sheet"
" where sheet.wonum > ' ' and sheet.sheettype in (1,7,8) and"
" sheet.wonum like '%'||wo.wonum||'%' and wo.wonum = worpt.wonum and"
" wo.wonum = wt.wonum and wo.wonum = wl.wonum and"
" wt.lockoutid = wl.lockoutid and wo.statusdate > sysdate - 365 and"
" wt.tagoutid not like 'JX%' and wl.devicedescription <> '?' and"
" wt.tagoutid <> '????' and wt.tagoutid <> '000THP002'"
About to enable constraints...
Import terminated successfully with warnings.
查询表发现有乱码,但是英文字符没任何问题,就是中文是乱码
SQL> select * from nls_database_parameters;
使用这个命令查看语言是都是NLS_CHARACTERSET
ZHS16GBK
导出系统是HP-UNIX 导入的系统为AIX 导出过程为:在HP服务器上导出,然后使用BIN传到IBM服务器上,不知道具体问题处在哪里?请高手指点 谢谢
作者: 小小鑫 发布时间: 2011-12-13
给自己顶下!
作者: 小小鑫 发布时间: 2011-12-13