IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_SM_ORGANIZATION" ("O"
"RG_ID","ORG_SN","ORG_NAME","PARENT_ID","PATH","LAYER","CHILDREN","CODE","JP"
"","QP","CREATINGTIME","CREATOR","ORGNUMBER","ORGDESC","REMARK1","REMARK2",""
"REMARK3","REMARK4","REMARK5","CHARGEORGID","SATRAPJOBID","ORG_LEVEL") AS "
"select a."ORG_ID",a."ORG_SN",a."ORG_NAME",a."PARENT_ID",a."PATH",a."LAYER","
"a."CHILDREN",a."CODE",a."JP",a."QP",a."CREATINGTIME",a."CREATOR",a."ORGNUMB"
"ER",a."ORGDESC",a."REMARK1",a."REMARK2",a."REMARK3",a."REMARK4",a."REMARK5""
",a."CHARGEORGID",a."ISPARTYBUSSINESS",a."SATRAPJOBID",a."ORG_LEVEL",a."ORG_"
"XZQM",a."ORG_CODE",a."ISDIRECTLYPARTY",a."ISFOREIGNPARTY",a."ISJICHAPARTY","
"a."ISDIRECTGUANHU",a."ORG_ADDR", level org_level from TD_SM_ORGANIZATION a"
" START WITH a.parent_id = '0' /*机构ID*/"
" CONNECT BY PRIOR a.org_id = a.parent_id"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_TD_CMS_DOCUMENT" ("D"
"OCUMENT_ID","TITLE","SUBTITLE","AUTHOR","CONTENT","CHANNEL_ID","STATUS","KE"
"YWORDS","DOCABSTRACT","DOCTYPE","DOCWTIME","TITLECOLOR","CREATETIME","CREAT"
"EUSER","DOCSOURCE_ID","DETAILTEMPLATE_ID","LINKTARGET","FLOW_ID","DOC_LEVEL"
"","DOC_KIND","PARENT_DETAIL_TPL","ISDELETED","AUDITTIME","PUBLISHTIME","GUI"
"DANGTIME","RECYCLETIME","GUIDANGMAN","RECYCLEMAN","VERSION","PIC_PATH","MED"
"IAPATH","PUBLISHFILENAME","COMMENT_TEMPLATE_ID","COMMENTSWITCH","SECONDTITL"
"E","EXT_1","EXT_2","EXT_3","EXT_888","ISNEW","NEWPIC_PATH","ORDERTIME","DET"
"AIL_TPL_ID") AS "
"select a."DOCUMENT_ID",a."TITLE",a."SUBTITLE",a."AUTHOR",a."CONTENT",a."CHA"
"NNEL_ID",a."STATUS",a."KEYWORDS",a."DOCABSTRACT",a."DOCTYPE",a."DOCWTIME",a"
"."TITLECOLOR",a."CREATETIME",a."CREATEUSER",a."DOCSOURCE_ID",a."DETAILTEMPL"
"ATE_ID",a."LINKTARGET",a."FLOW_ID",a."DOC_LEVEL",a."DOC_KIND",a."PARENT_DET"
"AIL_TPL",a."ISDELETED",a."AUDITTIME",a."PUBLISHTIME",a."GUIDANGTIME",a."REC"
"YCLETIME",a."GUIDANGMAN",a."RECYCLEMAN",a."VERSION",a."PIC_PATH",a."MEDIAPA"
"TH",a."PUBLISHFILENAME",a."COMMENT_TEMPLATE_ID",a."COMMENTSWITCH",a."SECOND"
"TITLE",a."EXT_1",a."EXT_2",a."EXT_3",a."EXT_888",a."ISNEW",a."NEWPIC_PATH","
"a."ORDERTIME",a."FILECONTENT",a."SEQ","
"case when parent_detail_tpl='0' then detailtemplate_id"
"else (select detail_tpl_id from td_cms_channel b where b.channel_id=a.chann"
"el_id)"
"end detail_tpl_id"
"from td_cms_document a"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_ALL_READ_INFO" ("ORG"
"_ID","ORG_NAME","USER_ID","USER_NAME","USER_REALNAME","USER_SEX","PERIODICA"
"L_ID","PERIODICAL_NAME_ID","LAST_READ_DATE","LAST_IP","READ_TIME") AS "
"select t.org_id,t.org_name,t.user_id,t.user_name,t.user_realname,t.user_sex"
", p.periodical_id,p.periodical_name_id,p.last_read_date,p.last_ip,p.read_ti"
"me"
" from v_user_org t"
" left join td_user_read_periodical p"
" on t.org_name=p.dept_name"
" and t.user_id=p.user_id"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_REPORT_SPARE_INFO" ("
""REPORT_INFO_ID","ANNUAL","REPORT_DEPT","INCEPT_DEPT","SECRET_STEP","REPORT"
"_INFO_HEAD","REPORT_INFO_THEME","REPORT_INFO_TEXT_PATH","REPORT_DATE","VISE"
"_LEAD","DUTY_EDITOR","STATUS","IS_READ","RETURN_PERSON","RETURN_MIND","RETU"
"RN_REPORT_DATE","REPORT_INFO_CONTENT","REPORT_INFO_TYPE_NAME","REPORT_INFO_"
"TYPE_ID","TYPE_STATUS","SPARE_TYPE_ID","SPARE_TYPE_NAME","SPARE_PERSON","SP"
"ARE_TIME") AS "
"select r."REPORT_INFO_ID",r."ANNUAL",r."REPORT_DEPT",r."APPROVE_PERSON_ID","
"r."REPORT_DEPTID",r."DEAL_PERSON",r."INCEPT_DEPT",r."APPROVE_DEPT",r."SECRE"
"T_STEP",r."REPORT_INFO_HEAD",r."REPORT_INFO_THEME",r."REPORT_INFO_TEXT_PATH"
"",r."REPORT_DATE",r."VISE_LEAD",r."DUTY_EDITOR",r."STATUS",r."IS_READ",r."R"
"ETURN_PERSON",r."RETURN_MIND",r."RETURN_REPORT_DATE",r."REPORT_INFO_CONTENT"
"",r."REPORT_INFO_TYPE_NAME",r."REPORT_INFO_TYPE_ID",r."TYPE_STATUS",s.spare"
"_type_id,s.spare_type_name,s.spare_person,s.spare_time"
" from v_report_info r,td_spare_info s"
" where r.report_info_id=s.spare_id"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_REPORT_AVISO_INFO" ("
""REPORT_INFO_ID","ANNUAL","REPORT_DEPT","INCEPT_DEPT","SECRET_STEP","REPORT"
"_INFO_HEAD","REPORT_INFO_THEME","REPORT_INFO_TEXT_PATH","REPORT_DATE","VISE"
"_LEAD","DUTY_EDITOR","STATUS","IS_READ","RETURN_PERSON","RETURN_MIND","RETU"
"RN_REPORT_DATE","REPORT_INFO_CONTENT","REPORT_INFO_TYPE_NAME","REPORT_INFO_"
"TYPE_ID","TYPE_STATUS","PERIODICAL_ID","IS_EXAM","PERIODICAL_NAME_ID","AVIS"
"O_DEPT","PERIODICAL_STATUS","AVISO_DATE","PERIODICAL_NAME") AS "
"select v."REPORT_INFO_ID",v."ANNUAL",v."REPORT_DEPT",v."APPROVE_PERSON_ID","
"v."REPORT_DEPTID",v."DEAL_PERSON",v."INCEPT_DEPT",v."APPROVE_DEPT",v."SECRE"
"T_STEP",v."REPORT_INFO_HEAD",v."REPORT_INFO_THEME",v."REPORT_INFO_TEXT_PATH"
"",v."REPORT_DATE",v."VISE_LEAD",v."DUTY_EDITOR",v."STATUS",v."IS_READ",v."R"
"ETURN_PERSON",v."RETURN_MIND",v."RETURN_REPORT_DATE",v."REPORT_INFO_CONTENT"
"",v."REPORT_INFO_TYPE_NAME",v."REPORT_INFO_TYPE_ID",v."TYPE_STATUS",t.perio"
"dical_id,t.is_exam,p.periodical_name_id,p.aviso_dept,p.status as periodical"
"_status,p.aviso_date,n.periodical_name"
" from v_report_info v,td_aviso_periodical_list t ,td_periodical_info p,t"
"d_periodical_name n where v.report_info_id = t.report_info_id and t.periodi"
"cal_id = p.periodical_id"
" and p.periodical_name_id = n.periodical_name_id"
即将启用约束条件...
成功终止导入, 但出现警告。
"CREATE FORCE VIEW "YYSYS"."V_SM_ORGANIZATION" ("O"
"RG_ID","ORG_SN","ORG_NAME","PARENT_ID","PATH","LAYER","CHILDREN","CODE","JP"
"","QP","CREATINGTIME","CREATOR","ORGNUMBER","ORGDESC","REMARK1","REMARK2",""
"REMARK3","REMARK4","REMARK5","CHARGEORGID","SATRAPJOBID","ORG_LEVEL") AS "
"select a."ORG_ID",a."ORG_SN",a."ORG_NAME",a."PARENT_ID",a."PATH",a."LAYER","
"a."CHILDREN",a."CODE",a."JP",a."QP",a."CREATINGTIME",a."CREATOR",a."ORGNUMB"
"ER",a."ORGDESC",a."REMARK1",a."REMARK2",a."REMARK3",a."REMARK4",a."REMARK5""
",a."CHARGEORGID",a."ISPARTYBUSSINESS",a."SATRAPJOBID",a."ORG_LEVEL",a."ORG_"
"XZQM",a."ORG_CODE",a."ISDIRECTLYPARTY",a."ISFOREIGNPARTY",a."ISJICHAPARTY","
"a."ISDIRECTGUANHU",a."ORG_ADDR", level org_level from TD_SM_ORGANIZATION a"
" START WITH a.parent_id = '0' /*机构ID*/"
" CONNECT BY PRIOR a.org_id = a.parent_id"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_TD_CMS_DOCUMENT" ("D"
"OCUMENT_ID","TITLE","SUBTITLE","AUTHOR","CONTENT","CHANNEL_ID","STATUS","KE"
"YWORDS","DOCABSTRACT","DOCTYPE","DOCWTIME","TITLECOLOR","CREATETIME","CREAT"
"EUSER","DOCSOURCE_ID","DETAILTEMPLATE_ID","LINKTARGET","FLOW_ID","DOC_LEVEL"
"","DOC_KIND","PARENT_DETAIL_TPL","ISDELETED","AUDITTIME","PUBLISHTIME","GUI"
"DANGTIME","RECYCLETIME","GUIDANGMAN","RECYCLEMAN","VERSION","PIC_PATH","MED"
"IAPATH","PUBLISHFILENAME","COMMENT_TEMPLATE_ID","COMMENTSWITCH","SECONDTITL"
"E","EXT_1","EXT_2","EXT_3","EXT_888","ISNEW","NEWPIC_PATH","ORDERTIME","DET"
"AIL_TPL_ID") AS "
"select a."DOCUMENT_ID",a."TITLE",a."SUBTITLE",a."AUTHOR",a."CONTENT",a."CHA"
"NNEL_ID",a."STATUS",a."KEYWORDS",a."DOCABSTRACT",a."DOCTYPE",a."DOCWTIME",a"
"."TITLECOLOR",a."CREATETIME",a."CREATEUSER",a."DOCSOURCE_ID",a."DETAILTEMPL"
"ATE_ID",a."LINKTARGET",a."FLOW_ID",a."DOC_LEVEL",a."DOC_KIND",a."PARENT_DET"
"AIL_TPL",a."ISDELETED",a."AUDITTIME",a."PUBLISHTIME",a."GUIDANGTIME",a."REC"
"YCLETIME",a."GUIDANGMAN",a."RECYCLEMAN",a."VERSION",a."PIC_PATH",a."MEDIAPA"
"TH",a."PUBLISHFILENAME",a."COMMENT_TEMPLATE_ID",a."COMMENTSWITCH",a."SECOND"
"TITLE",a."EXT_1",a."EXT_2",a."EXT_3",a."EXT_888",a."ISNEW",a."NEWPIC_PATH","
"a."ORDERTIME",a."FILECONTENT",a."SEQ","
"case when parent_detail_tpl='0' then detailtemplate_id"
"else (select detail_tpl_id from td_cms_channel b where b.channel_id=a.chann"
"el_id)"
"end detail_tpl_id"
"from td_cms_document a"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_ALL_READ_INFO" ("ORG"
"_ID","ORG_NAME","USER_ID","USER_NAME","USER_REALNAME","USER_SEX","PERIODICA"
"L_ID","PERIODICAL_NAME_ID","LAST_READ_DATE","LAST_IP","READ_TIME") AS "
"select t.org_id,t.org_name,t.user_id,t.user_name,t.user_realname,t.user_sex"
", p.periodical_id,p.periodical_name_id,p.last_read_date,p.last_ip,p.read_ti"
"me"
" from v_user_org t"
" left join td_user_read_periodical p"
" on t.org_name=p.dept_name"
" and t.user_id=p.user_id"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_REPORT_SPARE_INFO" ("
""REPORT_INFO_ID","ANNUAL","REPORT_DEPT","INCEPT_DEPT","SECRET_STEP","REPORT"
"_INFO_HEAD","REPORT_INFO_THEME","REPORT_INFO_TEXT_PATH","REPORT_DATE","VISE"
"_LEAD","DUTY_EDITOR","STATUS","IS_READ","RETURN_PERSON","RETURN_MIND","RETU"
"RN_REPORT_DATE","REPORT_INFO_CONTENT","REPORT_INFO_TYPE_NAME","REPORT_INFO_"
"TYPE_ID","TYPE_STATUS","SPARE_TYPE_ID","SPARE_TYPE_NAME","SPARE_PERSON","SP"
"ARE_TIME") AS "
"select r."REPORT_INFO_ID",r."ANNUAL",r."REPORT_DEPT",r."APPROVE_PERSON_ID","
"r."REPORT_DEPTID",r."DEAL_PERSON",r."INCEPT_DEPT",r."APPROVE_DEPT",r."SECRE"
"T_STEP",r."REPORT_INFO_HEAD",r."REPORT_INFO_THEME",r."REPORT_INFO_TEXT_PATH"
"",r."REPORT_DATE",r."VISE_LEAD",r."DUTY_EDITOR",r."STATUS",r."IS_READ",r."R"
"ETURN_PERSON",r."RETURN_MIND",r."RETURN_REPORT_DATE",r."REPORT_INFO_CONTENT"
"",r."REPORT_INFO_TYPE_NAME",r."REPORT_INFO_TYPE_ID",r."TYPE_STATUS",s.spare"
"_type_id,s.spare_type_name,s.spare_person,s.spare_time"
" from v_report_info r,td_spare_info s"
" where r.report_info_id=s.spare_id"
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YYSYS"."V_REPORT_AVISO_INFO" ("
""REPORT_INFO_ID","ANNUAL","REPORT_DEPT","INCEPT_DEPT","SECRET_STEP","REPORT"
"_INFO_HEAD","REPORT_INFO_THEME","REPORT_INFO_TEXT_PATH","REPORT_DATE","VISE"
"_LEAD","DUTY_EDITOR","STATUS","IS_READ","RETURN_PERSON","RETURN_MIND","RETU"
"RN_REPORT_DATE","REPORT_INFO_CONTENT","REPORT_INFO_TYPE_NAME","REPORT_INFO_"
"TYPE_ID","TYPE_STATUS","PERIODICAL_ID","IS_EXAM","PERIODICAL_NAME_ID","AVIS"
"O_DEPT","PERIODICAL_STATUS","AVISO_DATE","PERIODICAL_NAME") AS "
"select v."REPORT_INFO_ID",v."ANNUAL",v."REPORT_DEPT",v."APPROVE_PERSON_ID","
"v."REPORT_DEPTID",v."DEAL_PERSON",v."INCEPT_DEPT",v."APPROVE_DEPT",v."SECRE"
"T_STEP",v."REPORT_INFO_HEAD",v."REPORT_INFO_THEME",v."REPORT_INFO_TEXT_PATH"
"",v."REPORT_DATE",v."VISE_LEAD",v."DUTY_EDITOR",v."STATUS",v."IS_READ",v."R"
"ETURN_PERSON",v."RETURN_MIND",v."RETURN_REPORT_DATE",v."REPORT_INFO_CONTENT"
"",v."REPORT_INFO_TYPE_NAME",v."REPORT_INFO_TYPE_ID",v."TYPE_STATUS",t.perio"
"dical_id,t.is_exam,p.periodical_name_id,p.aviso_dept,p.status as periodical"
"_status,p.aviso_date,n.periodical_name"
" from v_report_info v,td_aviso_periodical_list t ,td_periodical_info p,t"
"d_periodical_name n where v.report_info_id = t.report_info_id and t.periodi"
"cal_id = p.periodical_id"
" and p.periodical_name_id = n.periodical_name_id"
即将启用约束条件...
成功终止导入, 但出现警告。
搞应用的兄弟查了下,这些视图procedure在源库本身就失败了,
所以imp 导过来时候连带着也就出了问题。
他们正在查循原因,为什么生产库也会有失效的procedure