导入dmp文件错误

[vivian_ms]

在导入最后报错，新手刚学oracle不懂，请教

IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "SYSTEM"."V_USERIDENTITY" ("USER"
"ID","PASSWORD") AS "
"select distinct(a.userid) as userid, NVL(b.password,MD5('888888')) as passw"
"ord"
" from v_user a left join t_sys_identity b on b.username = a.userid"
""
" union"
" select yhm as userid,MD5(mm) AS PASSWORD from t_khgl_yhxxzcb"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE TRIGGER "SYSTEM".TR_T_SBSJGL_YQSBSBSJB_DEL"
" after DELETE on T_SBSJGL_YQSBSBSJB"
" for each row"
" "
"begin"
" --当删除仪器设备上报数据表的数据时，更新仪器表的上报状态为空 "
" update T_NYYWSZ_YQSBDJ set sbzt=null where jbbh=:old.sbbm;"
" end;"
"BEGIN dbms_refresh.make('"USR_XD"."V_ZXBZ_ZC_YHZJ"',list=>null,next_date="
">null,interval=>null,implicit_destroy=>TRUE,lax=>FALSE,job=>24,rollback_seg"
"=>NULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option => "
"1,parallelism => 0,heap_size => 0); END;"
IMP-00003: 遇到 ORACLE 错误 1435
ORA-01435: 用户不存在
ORA-06512: 在"SYS.DBMS_IREFRESH", line 85
ORA-01403: 未找到数据
ORA-06512: 在"SYS.DBMS_REFRESH", line 83
ORA-06512: 在"SYS.DBMS_REFRESH", line 62
ORA-06512: 在line 1
IMP-00000: 未成功终止导入

[ahhaomaple]

对啊，把执行的imp命令贴出来吧！

[雪狼__]

用PLSQL导入不省事？

[孙成]

可能是导入时语句后面加 冒号了 去掉试试

[唐诗三百首]

楼主要把imp指令贴出来呀?

[girloflost]

要去掉role那一项的(用户不存在的错误)