连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options经由常规路径由 EXPORT:V10.02.01 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 MW_APP 的对象导入到 MW_APP
. . 正在导入表 "LCAM_GG_GGDM"导入了 65 行. (...........中间的导入过程我省略掉了............).. . 正在导入表 "MWT_UD_234324"导入了 0 行
. . 正在导入表 "TEST"导入了 6 行
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "MW_APP"."MWV_OM_USERINFO" ("USE"
"R_ID","USER_NAME","DEPTID","DEPTNAME","GLDW","GLDWMC","SSDW","SSDWMC","SSDW"
"JB","GLJB","DWJB","SSSJ","SSSJMC","SSFJ","SSFJMC","PDWHBZ","XLQXDW","SFXLGQ"
"RY","ZYXZ","EMPSMC","EMPID") AS "
"select t.user_id,t.user_name,deptAndEmp.deptid deptid"
" ,deptAndEmp.deptname,deptAndEmp.gldw,deptAndEmp.gldwmc,deptAndEmp.ssdw,d"
"eptAndEmp.ssdwmc,ssdwjb,deptAndEmp.gljb,deptAndEmp.dwjb,deptAndEmp.sssj,dep"
"tAndEmp.sssjmc,deptAndEmp.ssfj,"
" deptAndEmp.ssfjmc,deptAndEmp.pdwhbz,deptAndEmp.xlqxdw,deptAndEmp.sfxlgqr"
"y,deptAndEmp.zyxz ,deptAndEmp.empsmc,"
" deptAndEmp.empid from"
" (select emps.sysuserid,depts.obj_id deptid"
" ,depts.mc deptname,depts.gldw,depts.gldwmc,depts.ssdw,depts.ssdwmc,depts"
".ssdwjb,depts.gljb,depts.dwjb,depts.sssj,depts.sssjmc,depts.ssfj,depts.ssfj"
"mc,depts.pdwhbz,"
" depts.xlqxdw,depts.sfxlgqry,depts.zyxz ,emps.mc empsmc,emps.obj_id empid"
" from"
" (select a.obj_id,a.mc,a.zyxz,"
" ( select obj_id from mw_sys.mwt_pd_deps deps where a.gljb=deps.d"
"wjb and rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) gldw,"
" ( select mc from mw_sys.mwt_pd_deps deps where a.gljb=deps.dwjb "
"and rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) gldwmc,"
" ( select obj_id from mw_sys.mwt_pd_deps deps where deps.dwjb in ('7','6'"
",'4','3','2') and rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) ssdw,"
" ( select mc from mw_sys.mwt_pd_deps deps where deps.dwjb in ('7'"
",'6','4','3','2') and rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) ssdwmc,"
" ( select dwjb from mw_sys.mwt_pd_deps deps where deps.dwjb in ('"
"7','6','4','3','2') and rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) ssdwjb,"
" a.gljb,"
" a.dwjb ,"
" ( select obj_id from mw_sys.mwt_pd_deps deps where deps.dwjb='4'"
" and rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) sssj ,"
" ( select mc from mw_sys.mwt_pd_deps deps where deps.dwjb='4' and"
" rownum=1 start with deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id ) sssjmc ,"
" (select obj_id from mw_sys.mwt_pd_deps deps"
" where deps.dwjb='6' and rownum=1 start with"
" deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id"
" ) ssfj,"
" (select mc from mw_sys.mwt_pd_deps deps"
" where deps.dwjb='6' and rownum=1 start with"
" deps.obj_id=a.obj_id"
" connect by prior deps.sjbm=deps.obj_id"
" ) ssfjmc,"
" (select obj_id from mw_sys.mwt_pd_deps deps"
" where deps.dwjb='803' and"
" deps.obj_id=a.obj_id"
" ) pdwhbz,"
" (select obj_id from mw_sys.mwt_pd_deps gqb where"
" (gqb.dwjb='7'or gqb.sfdldw='T') and rownum=1 connect by prior gqb"
".sjbm=gqb.obj_id"
" start with gqb.obj_id=a.obj_id) xlqxdw,"
" (select case when nvl(gqb.dwjb,'')='7' then 'T' else 'F' end from"
" mw_sys.mwt_pd_deps gqb where"
" (gqb.dwjb='7'or gqb.sfdldw='T') and rownum=1 connect by prior gqb"
".sjbm=gqb.obj_id"
" start with gqb.obj_id=a.obj_id) sfxlgqry,"
" (select obj_id from mw_sys.mwt_pd_deps gqb where"
" (gqb.dwjb='7'or gqb.sfdldw='T') and rownum=1 connect by prior gqb"
".sjbm=gqb.obj_id"
" start with gqb.obj_id=a.obj_id)"
" from mw_sys.mwt_pd_deps a) depts"
" ,mw_sys.mwt_pd_emps emps where depts.obj_id=emps.lsbm"
" ) deptAndEmp,mw_sys.mwt_is_user t"
" where deptAndEmp.sysuserid(+)=t.user_id"
" "
""
成功终止导入, 但出现警告。在网上找了很久,基本有说没关系的,有说高低版本问题的,有说对象已存在的。
为什么会出现这个问题,要怎么解决呢??
imp system/sys@CAM_LOCALHOST file=D:\CAMFiles\camDmp\cam2009-11-10.DMP log=cam3rtm.log fromuser=rtm touser=rtm会在开始导入的时候弹出系统提示框:imp.exe遇到问题需要关闭,我们对此引起的不便表示歉意。发送。。不发送。。这个又是什么原因呢?是imp.exe自身的问题,还是导库过程中的什么问题导致的??各位大侠不要吝啬啊,帮个忙啊!