weixin_43780980 2020-05-19 00:50 采纳率: 50%
浏览 991

oracle备份导入新建的数据库中报: IMP-00041: 警告: 创建的对象带有编译警告

1.数据库版本是 11g
2.导出无报错;用的exp
3.导入语句是是:imp 1/2@orcl file=E:\3.DMP full=y ignore=y STATISTICS=NONE
4.在网上搜了一下只有重建视图,但是需要重建的视图太多,麻烦问一下有么有更加简单的方法,我小白一名
5.报错信息是:

```IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "P953"."PORTAL_CONTENT_UNION_VIEW" "
" ("SECTION_ID","REC_ID","TITLE","CONTENT","CREATE_DATE","IS_PUBLISH") A"
"S "
"SELECT A.SECTION_ID AS SECTION_ID, A.ARTICLE_ID AS REC_ID, A.ARTICLE_"
"TITLE AS TITLE, A.ARTICLE_CONTENT AS CONTENT, A.CREATE_DATE AS CREATE_DAT"
"E, A.IS_PUBLISH AS IS_PUBLISH FROM PORTAL_ARTICLE A UNION ALL SELECT P.S"
"ECTION_ID AS SECTION_ID, P.PHOTO_ID AS REC_ID, F.FILE_TITLE AS T"
"ITLE, F.MEMO AS CONTENT, F.UPLOAD_DATE AS CREATE_DATE, P.IS_PUBL"
"ISH AS IS_PUBLISH FROM PORTAL_PHOTO_FILE F JOIN PORTAL_PHOTO P ON F.PHOT"
"O_ID = P.PHOTO_ID UNION ALL SELECT M.SECTION_ID AS SECTION_ID, M.MEDIA_I"
"D AS REC_ID, F.FILE_TITLE AS TITLE, F.MEMO AS CONTENT, F.U"
"PLOAD_DATE AS CREATE_DATE, M.IS_PUBLISH AS IS_PUBLISH FROM PORTAL_MEDI"
"A_FILE F JOIN PORTAL_MEDIA M ON F.MEDIA_ID = M.MEDIA_ID"

  • 写回答

1条回答 默认 最新

  • Gyele 2020-05-19 14:40
    关注

    使用 expdp impdp 试下

    评论

报告相同问题?

悬赏问题

  • ¥50 易语言把MYSQL数据库中的数据添加至组合框
  • ¥20 求数据集和代码#有偿答复
  • ¥15 关于下拉菜单选项关联的问题
  • ¥20 java-OJ-健康体检
  • ¥15 rs485的上拉下拉,不会对a-b<-200mv有影响吗,就是接受时,对判断逻辑0有影响吗
  • ¥15 使用phpstudy在云服务器上搭建个人网站
  • ¥15 应该如何判断含间隙的曲柄摇杆机构,轴与轴承是否发生了碰撞?
  • ¥15 vue3+express部署到nginx
  • ¥20 搭建pt1000三线制高精度测温电路
  • ¥15 使用Jdk8自带的算法,和Jdk11自带的加密结果会一样吗,不一样的话有什么解决方案,Jdk不能升级的情况