升级服务器,用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: 警告: 创建的对象带有编译警告
 
..........省略................
成功终止导入,但出现警告。