Question

ORACLE11G IMP导入时出现问题，一个警告一个报错。IMP-00041: 遇到 ORACLE 错误 942 ORA-00942

IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "POS_USER8"."SKTXSJLDB" ("SKTNO","J"
"LBH","TCKT_INX","INX","DEPTID","SP_ID","LSDJ","XSSL","XSJE") AS "
"select "SKTNO","JLBH","TCKT_INX","INX","DEPTID","SP_ID","LSDJ","XSSL","XSJE"
"" from BFBHDD8.SKTXSJLDB"
""
""
""
" "

IMP-00017: 由于 ORACLE 错误 942, 以下语句失败:
"CREATE TRIGGER "BFCRM8"."TUB_HYK_JEZH" before update"
"of YE,TM"
"on BFCRM8.HYK_JEZH for each row"
"begin"
" select BFCRM8.T_HYK_JEZH.NextVal into :NEW.TM from dual;"
"end;"
""
""
""
IMP-00003: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在

求解如何操作能成功导入

Answer 1

就没有人说怎么解决吗？导入的时候就提示表或视图不存在。
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00041: Warning: object created with compilation warnings
"CREATE trigger LYASP.inser_CAS_SYSTEMS_"
" before insert on CAS_SYSTEMS"
" for each row"
""
"begin"
" select inser_CAS_SYSTEMS_next.nextval into:new.id from dual;"
"end;"
IMP-00017: following statement failed with ORACLE error 942:
"CREATE trigger LYASP.inser_LYASP_individuation_"
" before insert on WC_INDIVIDUATION"
" for each row"
""
"begin"
" select inser_lyasp_individuation_next.nextval into:new.id from dual;"
"end;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
Import terminated successfully with warnings.
完了系统都起不来。。。

Answer 2

其实两个问题 是ORACLE导入常碰见的问题，只要导入完确认下，你需要的视图和触发器均能正常访问或编译即可。

错误的原因：
执行建视图的时候涉及的函数或其它未先建立；
创建触发器时，涉及的表未先建立。

结果确认：实际上大多情况是，视图和触发器都正常建立。导入完毕后，进行确认视图是否可访问，触发器是否创建？

解决：如确认都正常，那就OK啦。如异常，大不了将错误的语句再执行次即可。

Answer 3

表不存在啊，你检查下表创建了没有

Answer 4

两个问题 一个是视图没有建立好 一个是dual表这样写应该不可以