升级服务器,用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: 警告: 创建的对象带有编译警告
..........省略................
成功终止导入,但出现警告。
但是在导入过程中出现一些错误提示,不知道对数据库有没有影响,请高手给分析以下错误所在,先谢谢了!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: 警告: 创建的对象带有编译警告
..........省略................
成功终止导入,但出现警告。
解决方案 »
- 两个或多个会话同时向一个表插入会怎么样?
- 对于oracle数据库过于庞大的处理问题,与大家讨论讨论,有经验的最好
- 棘手的问题!!!!!!!!
- 关系型数据库和非关系型数据库哪个更快?比如说我把一条记录按类型拆分到不同的表里,然后再查询出来。对比直接查询出一条记录哪个更快效
- a字段里有值为null的还有为空字符串的,为何用where取不出来?
- 在PL/SQL中运行时报出了这么一个错“ORA_01476:除数为0”请问是什么问题
- 如何临时禁止约束?
- 一个SQL查询问题
- 【求分析和解决】Oracle 先排序(order by),后(rownum=1),再锁一行的问题
- oracle12c的ogg数据采集add trandata出错
- 求SQL语句
- system用户不能登陆,怎么办啊?
-----------------------------------------------------------------------------------
在ORACLE8.04环境下单独运行ORACLE8.17版的EXP文件能运行吗?如果在ORACLE8.04环境下安装8.17的客户端对ORACLE8.04有没有影响.