重庆思庄Oracle、Redhat认证学习论坛

标题: imp导入出现ORA-06550、IMP-00017、IMP-00003告警 [打印本页]

作者: denglj 时间: 2022-12-9 11:48
标题: imp导入出现ORA-06550、IMP-00017、IMP-00003告警

问题描述：从oracle 11.2.0.4使用exp导出，然后imp导入oracle19.16，出现ORA-06550、IMP-00017、IMP-00003告警，如下所示：

[oracle@leo-19c-ogg~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

[oracle@leo-19c-ogg~]$ imp leo/leo file=/home/oracle/leo.dmp full=y

Import:Release 19.0.0.0.0 - Production on Thu Dec 1 10:56:14 2022

Version19.16.0.0.0

Connectedto: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version19.16.0.0.0

Exportfile created by EXPORT:V11.02.00 via conventional path

importdone in AL32UTF8 character set and AL16UTF16 NCHAR character set

exportserver uses UTF8 NCHAR character set (possible ncharset conversion)

.importing LEO's objects into LEO

. .importing table "LDEPT" 4 rowsimported

. .importing table "LEMP" 14 rowsimported

IMP-00017:following statement failed with ORACLE error 6550:

"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C007729"' "

" "

IMP-00003:ORACLE error 6550 encountered

ORA-06550:line 1, column 171:

PLS-00103:Encountered the symbol "end-of-file" when expecting one of thefollowing:

) , * & = - + < / > at in is modremainder not rem =>

<an exponent (**)> <> or != or~= >= <= <> and or like like2

like4 likec between || multiset membersubmultiset

IMP-00017:following statement failed with ORACLE error 6550:

"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C007730"' "

" "

" tensible indexes"

IMP-00003:ORACLE error 6550 encountered

ORA-06550:line 1, column 172:

PLS-00103:Encountered the symbol "TENSIBLE" when expecting one of thefollowing:

) , * & = - + < / > at in is modremainder not rem =>

<an exponent (**)> <> or != or~= >= <= <> and or like like2

like4 likec between || multiset membersubmultiset

Importterminated successfully with warnings.

[oracle@leo-19c-ogg~]$ sqlplus / as sysdba

SQL*Plus:Release 19.0.0.0.0 - Production on Thu Dec 1 10:57:18 2022

Version19.16.0.0.0

Connectedto:

OracleDatabase 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version19.16.0.0.0

SQL>conn leo/leo;

Connected.

SQL>set line 200

SQL>select * from lemp

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

-------------------- --------- ---------- ------------------ ---------- --------------------

7369 SMITH CLERK 7902 17-DEC-80 800 20

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30

7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30

7566 JONES MANAGER 7839 02-APR-81 2975 20

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30

7698 BLAKE MANAGER 7839 01-MAY-81 2850 30

7782 CLARK MANAGER 7839 09-JUN-81 2450 10

7788 SCOTT ANALYST 7566 19-APR-87 3000 20

7839 KING PRESIDENT 17-NOV-81 5000 10

7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30

7876 ADAMS CLERK 7788 23-MAY-87 1100 20

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

-------------------- --------- ---------- ------------------ ---------- --------------------

7900 JAMES CLERK 7698 03-DEC-81 950 30

7902 FORD ANALYST 7566 03-DEC-81 3000 20

7934 MILLER CLERK 7782 23-JAN-82 1300 10

14 rowsselected.

SQL>select * from ldept;

DEPTNO DNAME LOC

------------------------ -------------

10 ACCOUNTING NEW YORK

20 RESEARCH DALLAS

30 SALES CHICAGO

40 OPERATIONS BOSTON

异常原因：

该导入告警很常见，通常与源端以及目标端数据库版本有关.

解决方案：

使用exp或imp时加参数禁用统计信息的导出/导入：statistic=none

[oracle@leo-19c-ogg~]$ imp leo/leo file=/home/oracle/leo.dmp full=y statistics=none

Import:Release 19.0.0.0.0 - Production on Thu Dec 1 11:31:13 2022

Version19.16.0.0.0

Connectedto: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version19.16.0.0.0

Exportfile created by EXPORT:V11.02.00 via conventional path

importdone in AL32UTF8 character set and AL16UTF16 NCHAR character set

exportserver uses UTF8 NCHAR character set (possible ncharset conversion)

.importing LEO's objects into LEO

. .importing table "LDEPT" 4 rowsimported

. .importing table "LEMP" 14 rows imported

Importterminated successfully without warnings.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)