IMP导入常见错误及解决方法

 在做IMP导入的时候经常会碰到一些常见的错误，我在这里列举出来，希望有所帮助

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

 创建表时，出现中文字符列名导致imp报错。导出端和导入端的字符集不一样，
 解决方法   导入端使用american
2. IMP-00003: 遇到 ORACLE 错误 604
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_OBJ#_INTCOL# by 128 in tablespace SYSTEM
ORA-06512: at "SYS.DBMS_STATS", line 4858
ORA-06512: at "SYS.DBMS_STATS", line 5081
ORA-06512: at line 1
IMP-00017: 由于 ORACLE 错误 604, 以下语句失败:

 数据库里面建立object时,数据字典要记录了,数据字典的索引当然要相应增长,system表空间太小就会导致这个错误，
 解决方法  加大system空间。

 3. IMP-00003: 遇到 ORACLE 错误 1031
ORA-01031: insufficient privileges
  缺失权限 

解决方法 权限的分配根据具体错误才给予  如

IMP-00003: 遇到 ORACLE 错误 1031
ORA-01031: insufficient privileges
IMP-00017: 由于 ORACLE 错误 1031, 以下语句失败:
 "CREATE DATABASE LINK "COMM" CONNECT TO "QRY" IDENTIFIED BY VALUES '055E952E"
 "3B430ABC87D1C27969E7E47D98' USING '(DESCRIPTION ="
 "    (ADDRESS_LIST ="
 "      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.117.61)(PORT = 1521))"
 "    )"
 "    (CONNECT_DATA ="
 "      (SERVICE_NAME = comm)"
 "    )"
 "  )'"

需要添加创建dblink的权限   grant  create database link to username.
4.  IMP-00003: 遇到 ORACLE 错误 4043
IMP-00017: 由于 ORACLE 错误 4043, 以下语句失败:
ORA-04030 out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.

解决方法  添加语句 buffer=100000000

5.  ORA-04043:   错误

object BATCH_P_CS_RULES_TEST does not exist
 目标不存在

解决方法   导入语句后面添加  ignore=y