在导入最后报错,新手刚学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: 未成功终止导入
"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: 未成功终止导入
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货