oracle导入一半,oracle导入的问题

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

经由常规路径由 EXPORT:V10.02.01 创建的导出文件

警告: 这些对象由 YXOA 导出, 而不是当前用户

已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入

. 正在将 YXOA 的对象导入到 XIAO

IMP-00017: 由于 ORACLE 错误 4063, 以下语句失败:

"BEGIN "

"sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','"

"CURRENT_SCHEMA'), export_db_name=>'ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM', i"

"nst_scn=>'8359104');"

"COMMIT; END;"

IMP-00003: 遇到 ORACLE 错误 4063

IMP-00041: 警告: 创建的对象带有编译警告

"CREATE FORCE VIEW "XIAO"."OA_OUTFITSTOCK_VIEW" ("

""OSQ_GUID","OSQ_NO","OSQ_TITLE","OSQ_UNITID","OSQ_UNITNAME","OSQ_CREATETIME"

"","OSQ_CREATORID","OSQ_CREATORNAME","OSQ_IMPORTANT","OSQ_CONFIDENTIAL","OSQ"

"_CONTACT","OSQ_BPLAN","OSQ_MONEYSOURCE","OSQ_BFINISH","OSQ_LASTTIME","OSQ_C"

"ONTENT","OSQ_REMARK","OSQ_ATTACH","FILENUM","TRANSACTOR_ID","TRANSACTOR_NAM"

"E","DEPUTY_ID","DEPUTY_NAME","DIRECTOR_ID","DIRECTOR_NAME","BPC_VIEWS","BPC"

"_RESULT","BPC_HANDLER","BPC_HANDLERID","BPC_TIME","INF_VIEWS","INF_RESULT","

""INF_HANDLER","INF_HANDLERID","INF_TIME","DEV_VIEWS","DEV_RESULT","DEV_HAND"

"LER","DEV_HANDLERID","DEV_TIME","FIN_VIEWS","FIN_RESULT","FIN_HANDLER","FIN"

"_HANDLERID","FIN_TIME","DEP_VIEWS","DEP_RESULT","DEP_HANDLER","DEP_HANDLERI"

"D","DEP_TIME","DIR_VIEWS","DIR_RESULT","DIR_HANDLER","DIR_HANDLERID","DIR_T"

"IME","CUR_NODE","CUR_STATUS","JQ_STATUS","BPCDIR_VIEWS","BPCDIR_RESULT","BP"

"CDIR_HANDLER","BPCDIR_HANDLERID","BPCDIR_TIME","ADDTIME") AS "

"SELECT "OSQ_GUID","OSQ_NO","OSQ_TITLE","OSQ_UNITID","OSQ_UNITNAME","OSQ_CRE"

"ATETIME","OSQ_CREATORID","OSQ_CREATORNAME","OSQ_IMPORTANT","OSQ_CONFIDENTIA"

"L","OSQ_CONTACT","OSQ_BPLAN","OSQ_MONEYSOURCE","OSQ_BFINISH","OSQ_LASTTIME""

","OSQ_CONTENT","OSQ_REMARK","OSQ_ATTACH","FILENUM","TRANSACTOR_ID","TRANSAC"

"TOR_NAME","DEPUTY_ID","DEPUTY_NAME","DIRECTOR_ID","DIRECTOR_NAME","BPC_VIEW"

"S","BPC_RESULT","BPC_HANDLER","BPC_HANDLERID","BPC_TIME","INF_VIEWS","INF_R"

"ESULT","INF_HANDLER","INF_HANDLERID","INF_TIME","DEV_VIEWS","DEV_RESULT","D"

"EV_HANDLER","DEV_HANDLERID","DEV_TIME","FIN_VIEWS","FIN_RESULT","FIN_HANDLE"

"R","FIN_HANDLERID","FIN_TIME","DEP_VIEWS","DEP_RESULT","DEP_HANDLER","DEP_H"

"ANDLERID","DEP_TIME","DIR_VIEWS","DIR_RESULT","DIR_HANDLER","DIR_HANDLERID""

","DIR_TIME","CUR_NODE","CUR_STATUS","JQ_STATUS","BPCDIR_VIEWS","BPCDIR_RESU"

"LT","BPCDIR_HANDLER","BPCDIR_HANDLERID","BPCDIR_TIME","ADDTIME" FROM OA_OUT"

"FITSTOCK_HIS"

"UNION ALL"

"SELECT T."OSQ_GUID",T."OSQ_NO",T."OSQ_TITLE",T."OSQ_UNITID",T."OSQ_UNITNAME"

"",T."OSQ_CREATETIME",T."OSQ_CREATORID",T."OSQ_CREATORNAME",T."OSQ_IMPORTANT"

"",T."OSQ_CONFIDENTIAL",T."OSQ_CONTACT",T."OSQ_BPLAN",T."OSQ_MONEYSOURCE",T."

""OSQ_BFINISH",T."OSQ_LASTTIME",T."OSQ_CONTENT",T."OSQ_REMARK",T."OSQ_ATTACH"

"",T."FILENUM",T."TRANSACTOR_ID",T."TRANSACTOR_NAME",T."DEPUTY_ID",T."DEPUTY"

"_NAME",T."DIRECTOR_ID",T."DIRECTOR_NAME",T."BPC_VIEWS",T."BPC_RESULT",T."BP"

"C_HANDLER",T."BPC_HANDLERID",T."BPC_TIME",T."INF_VIEWS",T."INF_RESULT",T."I"

"NF_HANDLER",T."INF_HANDLERID",T."INF_TIME",T."DEV_VIEWS",T."DEV_RESULT",T.""

"DEV_HANDLER",T."DEV_HANDLERID",T."DEV_TIME",T."FIN_VIEWS",T."FIN_RESULT",T."

""FIN_HANDLER",T."FIN_HANDLERID",T."FIN_TIME",T."DEP_VIEWS",T."DEP_RESULT",T"

"."DEP_HANDLER",T."DEP_HANDLERID",T."DEP_TIME",T."DIR_VIEWS",T."DIR_RESULT","

"T."DIR_HANDLER",T."DIR_HANDLERID",T."DIR_TIME",T."CUR_NODE",T."CUR_STATUS","

"T."JQ_STATUS",T."BPCDIR_VIEWS",T."BPCDIR_RESULT",T."BPCDIR_HANDLER",T."BPCD"

"IR_HANDLERID",T."BPCDIR_TIME",NULL FROM OA_OUTFITSTOCK T"

IMP-00041: 警告: 创建的对象带有编译警告

"CREATE FORCE VIEW "XIAO"."XGO_USER_VIEW" ("USERG"

"UID","USERID","USERNAME","USERTYPE","PASSWORD","DEPTID") AS "

"SELECT A.JZGBH,USERID,XM,"

"CASE B.DEPTTYPE WHEN 'dtSchool' THEN 'utScTeacher' WHEN 'dtEdu' THEN 'utEdu"

"Teacher' when 'dtImme' then 'utImmeTeacher' ELSE 'utGrpTeacher' END USERTYP"

"E,"

"PASSWORD,XXDM"

"FROM EBD_TEACHER_JBXX A,XGO_DEPT_VIEW B"

"WHERE A.XXDM=B.DEPTID"

"union all"

"select GUID,USERID,USERNAME,'utEduTeacher', PASSWORD,SC_ID from SDMS_SUPER"

IMP-00017: 由于 ORACLE 错误 942, 以下语句失败:

"ALTER TABLE "SDMS_LESSONGROUP_MEMBER" ADD CONSTRAINT "FK_SDMS_MEMBER_LESSON"

"SGROUP" FOREIGN KEY ("LG_ID") REFERENCES "SDMS_LESSONGROUP" ("LG_ID") ON DE"

"LETE CASCADE ENABLE NOVALIDATE"

IMP-00003: 遇到 ORACLE 错误 942

ORA-00942: 表或视图不存在

"BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('YXOA','OA_INFOSTOCK'); END;"

IMP-00003: 遇到 ORACLE 错误 1435

ORA-01435: 用户不存在

ORA-06512: 在 "SYS.DBMS_ISNAPSHOT", line 108

ORA-06512: 在 "SYS.DBMS_SNAPSHOT_UTL", line 1723

ORA-06512: 在 line 1

IMP-00000: 未成功终止导入

速求回复！谢谢！