```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"
对于Oracle来说,IMP导入命令根据EXP导出方式采用的方式有所不同。
EXP以“全数据库方式”和“表空间方式”导出的数据库,IMP需要有DBA权限,并且导入数据库要有与导出数据库一致的表空间。
例:EXP system/口令@连接串... ...
IMP system/口令@连接串... ...
EXP以“用户方式”和“表方式”导出的用户和表,IMP需要有被导入的用户与导出用户一致的权限,用户名可以不同,表名需要一致。
例:EXP scott/tiger@orcl ... ...
IMP 用户名/kouling@orcl ... ...
有时出现警告信息也没有问题的。查看一下被安装数据是否正确。
一周热门 更多>