ITPUB论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 1608|回复: 1

[备份恢复] IMP导入出现一些错误,高手帮忙分析下原因! [复制链接]

注册会员

初级会员

精华贴数
0
专家积分
0
技术积分
8
社区积分
0
注册时间
2007-6-9
论坛徽章:
0
发表于 2007-6-9 02:16:31 |显示全部楼层
升级服务器,用ORACLE8.04的EXP80导出后,升级到ORACLE8i(8.16) 用IMP导入到ORACLE8i中,导入后数据和对象后,数据库可正常使用。
但是在导入过程中出现一些错误提示,不知道对数据库有没有影响,请高手给分析以下错误所在,先谢谢了!

ORACLE8.04的表空间名自定义)1. DLCK(类型:永久)  2. DLCK_TEMP(类型:临时)  
                    (系统生成) 1.ROLLBACK_DATA   2.SYSTEM  3.TEMPORARY_DATA  4.USER_DATA
ORACLE8i  的表空间名:(自定义) 1.DLCK(类型:永久)2.DLCK_TEMP(类型:临时)  3.ROLLBACK_DATA   4.SYSTEM  5.TEMPORARY_DATA  6.USER_DATA

                 (系统生成) 1.INDX  2.RBS 3.SYSTEM 4.TEMP 5.TOOLS 6.USERS
-----------------------------------------------------------------------
连接到: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

经由常规路径导出由EXPORT:V08.00.04创建的文件
已经完成ZHS16GBK字符集和ZHS16GBK NCHAR 字符集中的导入
IMP-00015: 由于对象已存在, 下列语句失败:    \\●为什么建立相应空间名后,出现下面的错误.不建立空间名,它会提示空间不存在,无法创建!无论怎样都有错误●\\
"CREATE TABLESPACE "USER_DATA" DATAFILE  'D:\ORANT\DATABASE\USR1ORCL.ORA' SI"
"ZE 3145728       DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAX"
"EXTENTS 121 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLESPACE "ROLLBACK_DATA" DATAFILE  'D:\ORANT\DATABASE\RBS1ORCL.ORA"
"' SIZE 41943040       DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS "
"1 MAXEXTENTS 121 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLESPACE "TEMPORARY_DATA" DATAFILE  'D:\ORANT\DATABASE\TMP1ORCL.OR"
"A' SIZE 2097152       DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS "
"1 MAXEXTENTS 121 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLESPACE "DLCK" DATAFILE  'D:\ORANT\DATABASE\DLCK1.DAT' SIZE 21223"
"17824       DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTEN"
"TS 121 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLESPACE "DLCK_TEMP" DATAFILE  'D:\ORANT\DATABASE\DLCK_TEMP' SIZE "
"314572800       DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXE"
"XTENTS 121 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'E066D214D5421CCC'"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE ROLE "AQ_ADMINISTRATOR_ROLE""
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE ROLE "SELECT_CATALOG_ROLE""
IMP-00015: 由于对象已存在, 下列语句失败:
"REVOKE "SELECT_CATALOG_ROLE" FROM SYSTEM"

..........省略................

. 正在将SYSTEM的对象导入到 SYSTEM
IMP-00015: 由于对象已存在, 下列语句失败:
"ALTER TABLE "DEF$_CALLDEST" ADD CONSTRAINT "DEF$_CALL_DESTINATION" FOREIGN "
"KEY ("DBLINK" REFERENCES "DEF$_DESTINATION" ("DBLINK" ENABLE NOVALIDATE"
. 正在将MDSYS的对象导入到 MDSYS
. 正在将GKK的对象导入到 GKK
. 正在将SYSTEM的对象导入到 SYSTEM     \\●出现下面错误都是什么原因啊?●\\
IMP-00017: 由于 ORACLE 错误6550,以下的语句失败
"BEGIN   SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_TABLE_DEFN_UPDATE('SYSTEM','DEF$_AQC"
"ALL',2,0,2,''); END;"
IMP-00003: ORACLE 错误6550出现
ORA-06550: 第 1 行, 第 9 列:
PLS-00306: 调用 'AQ_TABLE_DEFN_UPDATE' 时参数数量或类型错误
ORA-06550: 第 1 行, 第 9 列:
PL/SQL: Statement ignored
IMP-00017: 由于 ORACLE 错误24021,以下的语句失败
"BEGIN   SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE(HEXTORAW('7D0F46DF6DDA11"
"D1A02800C04FB9DC04'),'SYSTEM','DEF$_AQCALL','AQ$_DEF$_AQCALL_E',1,0,0,0,0,'"
"exception queue'); END;"
IMP-00003: ORACLE 错误24021出现
ORA-24021: 没有为AQ$_DEF$_AQCALL_E.导入队列表格定义
ORA-06512: 在"SYS.DBMS_AQ_IMPORT_INTERNAL", line 388
ORA-06512: 在line 1
IMP-00017: 由于 ORACLE 错误24021,以下的语句失败
"BEGIN   SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE(HEXTORAW('7D0F46E06DDA11"
"D1A02800C04FB9DC04'),'SYSTEM','DEF$_AQCALL','DEF$_AQCALL',0,0,0,1,0,'Deferr"
"ed RPC Queue'); END;"
IMP-00003: ORACLE 错误24021出现
ORA-24021: 没有为DEF$_AQCALL.导入队列表格定义
ORA-06512: 在"SYS.DBMS_AQ_IMPORT_INTERNAL", line 388
ORA-06512: 在line 1
IMP-00017: 由于 ORACLE 错误6550,以下的语句失败
"BEGIN   SYS.DBMS_REPCAT.REPCAT_IMPORT_REPSCHEMA; END;"
IMP-00003: ORACLE 错误6550出现
ORA-06550: 第 1 行, 第 9 列:
PLS-00201: 必须说明标识符 'SYS.DBMS_REPCAT'
ORA-06550: 第 1 行, 第 9 列:
PL/SQL: Statement ignored
. 正在将GYQ的对象导入到 GYQ
. 正在将SYSTEM的对象导入到 SYSTEM
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE PUBLIC SYNONYM "DUAL" FOR "SYS"."DUAL""
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE PUBLIC SYNONYM "SYSTEM_PRIVILEGE_MAP" FOR "SYS"."SYSTEM_PRIVILEGE_MA"
"P""
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE PUBLIC SYNONYM "TABLE_PRIVILEGE_MAP" FOR "SYS"."TABLE_PRIVILEGE_MAP""
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE PUBLIC SYNONYM "STMT_AUDIT_OPTION_MAP" FOR "SYS"."STMT_AUDIT_OPTION_"
"MAP""

..........省略................

. 正在将YBK的对象导入到 YBK
IMP-00041: 警告: 创建的对象带有编译警告      \\●一般出编译警告是什么原因啊?●\\
"CREATE FORCE VIEW "YBK"."VZBJCKDV"                             ("FCKMC","FR"
"QVV","FCKDH","FBHVV","FMCVV","FGGMC","FJLDW","FSLVV","FDJVV","FJEVV","FCDBH"
"","FCDMC","FSCRQ","FSXRQ","FHWVV","FFJHR","FFFLR","FFSKY","FLZGR","FLSLR",""
"FLZBR","FLLBM","FZJBH","FZJMC","FYYVV","FBZVV","FLBBH","FLBMC","FTHMC","FCZ"
"MC" AS "
"select "FCKMC","FRQVV","FCKDH","FBHVV","FMCVV","FGGMC","FJLDW","FSLVV","FDJ"
"VV","FJEVV","FCDBH","FCDMC","FSCRQ","FSXRQ","FHWVV","FFJHR","FFFLR","FFSKY""
","FLZGR","FLSLR","FLZBR","FLLBM","FZJBH","FZJMC","FYYVV","FBZVV","FLBBH","F"
"LBMC","FTHMC","FCZMC" from clk.zzbjckdv "
"union"
"select "FCKMC","FRQVV","FCKDH","FBHVV","FMCVV","FGGMC","FJLDW","FSLVV","FDJ"
"VV","FJEVV","FCDBH","FCDMC","FSCRQ","FSXRQ","FHWVV","FFJHR","FFFLR","FFSKY""
","FLZGR","FLSLR","FLZBR","FLLBM","FZJBH","FZJMC","FYYVV","FBZVV","FLBBH","F"
"LBMC","FTHMC","FCZMC" from dqk.zzbjckdv "
"union"
"select "FCKMC","FRQVV","FCKDH","FBHVV","FMCVV","FGGMC","FJLDW","FSLVV","FDJ"
"VV","FJEVV","FCDBH","FCDMC","FSCRQ","FSXRQ","FHWVV","FFJHR","FFFLR","FFSKY""
","FLZGR","FLSLR","FLZBR","FLLBM","FZJBH","FZJMC","FYYVV","FBZVV","FLBBH","F"
"LBMC","FTHMC","FCZMC" from gkk.zzbjckdv "
"union"
"select "FCKMC","FRQVV","FCKDH","FBHVV","FMCVV","FGGMC","FJLDW","FSLVV","FDJ"
"VV","FJEVV","FCDBH","FCDMC","FSCRQ","FSXRQ","FHWVV","FFJHR","FFFLR","FFSKY""
","FLZGR","FLSLR","FLZBR","FLLBM","FZJBH","FZJMC","FYYVV","FBZVV","FLBBH","F"
"LBMC","FTHMC","FCZMC" from ybk.zzbjckdv "
"union"
"select "FCKMC","FRQVV","FCKDH","FBHVV","FMCVV","FGGMC","FJLDW","FSLVV","FDJ"
"VV","FJEVV","FCDBH","FCDMC","FSCRQ","FSXRQ","FHWVV","FFJHR","FFFLR","FFSKY""
","FLZGR","FLSLR","FLZBR","FLLBM","FZJBH","FZJMC","FYYVV","FBZVV","FLBBH","F"
"LBMC","FTHMC","FCZMC" from ykk.zzbjckdv "
IMP-00041: 警告: 创建的对象带有编译警告

..........省略................
成功终止导入,但出现警告。

版主

版主

精华贴数
2
专家积分
208
技术积分
47894
社区积分
31729
注册时间
2002-10-29
认证徽章
论坛徽章:
320
兰博基尼
日期:2013-08-02 11:34:52奔驰
日期:2013-08-03 12:35:47奔驰
日期:2013-08-02 11:38:46复活蛋
日期:2014-07-29 14:08:32Jeep
日期:2013-09-26 13:03:51Jeep
日期:2013-09-24 12:52:10大众
日期:2013-09-23 21:16:10比亚迪
日期:2013-09-23 21:02:32日产
日期:2013-09-22 20:06:54现代
日期:2013-09-22 11:44:37福特
日期:2013-09-22 08:40:42三菱
日期:2013-09-22 08:36:46
发表于 2007-6-9 08:45:52 |显示全部楼层
don't worry, just ignore the system error.
or you can try the fromuser touser in imp

使用道具 举报


您需要登录后才可以回帖 登录 | 注册

2014中国系统架构师大会(9.17-19)
SACC2014正式启动 会员购票7.8折

大会时间:2014年9月17日-19日
大会地点:北京五洲皇冠国际酒店
大会主题:发现架构之美
金秋9月,2014第六届中国系统架构师大会将如期而至。新的场地新的规模,欢迎参与,报名从速~~

查看详情>>
TOP技术积分榜 社区积分榜 徽章 电子杂志 团队 统计 邮箱 虎吧 老博客 知识索引树 读书频道 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档 | IT博客
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛 | IXPUB | SAP ERP系统
CopyRight 1999-2011 itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有 联系我们 网站律师 隐私政策 知识产权声明
京ICP证:060528号 北京市公安局海淀分局网监中心备案编号:1101082001 广播电视节目制作经营许可证:编号(京)字第1149号
  
回顶部