新手求助Oracle

qq_34904243 2016-08-06 10:52:28
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "SDE"."SMP_VDN_VIEW_TARGET_LIST" "
" ("ID","NAME","DESCRIPTION","TYPE","NODE","TNSADDR","USERDATA","AGENT",""
"TOTALBLACKOUT") AS "
"SELECT"
" target.id,"
" target.name,"
" target.description,"
" type.name,"
" node.name,"
" target.TNSAddr,"
" target.UserData,"
" node.agent,"
" target.totalblackout"
" FROM"
" smp_vdn_target_list target,"
" smp_vdn_node_list node,"
" smp_vdn_target_type_defn type"
" WHERE"
" target.nodeid = node.id AND"
" target.typeid = type.id"

IMP-00041: 警告: 创建的对象带有编译警告
"CREATE TRIGGER SDE.V337_UPDATE INSTEAD OF UPDATE ON SDE.VST_FZD FOR EACH RO"
"W DECLARE current_state sde.version_util.state_id_t := sde.version_util.cur"
"rent_state; spatial_id SDE.ST_FZD.SHAPE%TYPE; shapes_found BOOLEAN; CURSOR "
"shape_ref_cursor IS SELECT SHAPE FROM SDE.ST_FZD WHERE SHAPE = :old.SHAPE U"
"NION ALL SELECT SHAPE FROM SDE.A337 WHERE SHAPE = :old.SHAPE; BEGIN IF :new"
".SHAPE IS NOT NULL AND :new.SHAPE <> :old.SHAPE THEN raise_application_erro"
"r (sde.sde_util.SE_INVALID_SPATIAL_COLUMN,'Attempted insert of non-NULL val"
"ue into ' || 'spatial column'); END IF; sde.version_util.current_version_wr"
"itable; IF :old.sde_state_id != current_state THEN INSERT INTO SDE.A337 VAL"
"UES (:old.OBJECTID,:new.FZD_ID,:new.ZD_ID,:new.FZD_ZH,:new.FZD_FH,:new.SHAP"
"E,current_state); INSERT INTO SDE.D337 (DELETED_AT,SDE_DELETES_ROW_ID,SDE_S"
"TATE_ID) VALUES (current_state, :old.OBJECTID,:old.sde_state_id); ELSE UPDA"
"TE SDE.A337 SET FZD_ID = :new.FZD_ID,ZD_ID = :new.ZD_ID,FZD_ZH = :new.FZD_Z"
"H,FZD_FH = :new.FZD_FH,SHAPE = :new.SHAPE WHERE OBJECTID = :old.OBJECTID AN"
"D sde_state_id = :old.sde_state_id; IF :old.SHAPE IS NOT NULL THEN OPEN sha"
"pe_ref_cursor; FETCH shape_ref_cursor INTO spatial_id; shapes_found := shap"
"e_ref_cursor%FOUND; CLOSE shape_ref_cursor; IF NOT shapes_found THEN DELETE"
" FROM SDE.F265 WHERE fid = :old.SHAPE; DELETE FROM SDE.S265 WHERE sp_fid "
"= :old.SHAPE; END IF; END IF; END IF; sde.version_util.flag_mvtable_modifie"
"d (337,current_state); END;"
...全文
362 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
ghx287524027 2016-08-08
  • 打赏
  • 举报
回复
导入完成之后重建一下预警的视图
jiezhang__zj 2016-08-07
  • 打赏
  • 举报
回复
可能是数据导入的过程中,用户有视图对象,而视图需要引用的对象在其他用户里。
卖水果的net 2016-08-07
  • 打赏
  • 举报
回复
导入完成后,你用 plsql 看看,具体是什么错误: 1.基表(视图)不存在; 2.列不存在;

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧