IMP-00003: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel
. . importing table "SFP_FILE_6" 11179 rows imported
IMP-00017
: following statement failed with ORACLE error 3113:
![](https://i-blog.csdnimg.cn/blog_migrate/cb6fb5e2eacf846d2ca29c9238aa5f13.gif)
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '42'; SREC.MAXVAL :="
" '564C'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUM"
"ARRAY(342691592663299000000000000000000000,44807899296387300000000000000000"
"0000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.S"
"ET_COLUMN_STATS(NULL,'"SFP_FILE_6"','"SFPGRUP"', NULL ,NULL,NULL,10,.1,0,sr"
"ec,3,6); END;"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP- 00000: Import terminated unsuccessfully
1
LOB字段导入遇出现ORA- 00959错误, 并由此引发IMP- 00017和IMP- 00003错误
原创作品,允许转载,转载时请务必以超链接形式标明文章
原始出处 、作者信息和本声明。否则将追究法律责任。
http://2874575.blog.51cto.com/2864575/1138470
今天导数据,imp时出现错误:
- IMP-00017: following statement failed with ORACLE error 959:
- "CREATE TABLE "SYS_FORMFILEINFO" ("FPKID" NUMBER(22, 0) NOT NULL ENABLE, "FO"
- "RMTYPE" VARCHAR2(50), "FORMINFO" CLOB, "DESCRIPTION" VARCHAR2(200), "FORMNA"
- "ME" VARCHAR2(50), "FLASTUPDATE" DATE, "FTYPE" NUMBER(22, 0)) PCTFREE 10 PC"
- "TUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
- " GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SRM_STANDARD" LOGGING NOCOMPRESS"
- " LOB ("FORMINFO") STORE AS (TABLESPACE "SRM_STANDARD" ENABLE STORAGE IN RO"
- "W CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS"
- " 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
- IMP-00003: ORACLE error 959 encountered
- ORA-00959: tablespace 'SRM_STANDARD' does not exist
- . . importing table "SYS_BUSINESS_GLIDE" 0 rows imported
- About to enable constraints...
表SYS_FORMFILEINFO 含有LOB字段,导入时出现IMP-00017,IMP-00003,ORA-00959。
为避免此错误,解决方案如下,
方法A:
在导入的数据库中建立与原数据库一样名称的tablespace(当然,只需要建立 有LOB字段的table相关的tablespace即可)
方法B
先在导入的数据库中手动建立带LOB的table,再用ignore=Y来导入
方法C
PLDEV的导入导出工具
因为我知道源库的连接信息,因此可以查到含有LOB字段表相关的表空间,也可以获取含LOB字段表的建表语句,我选择方法B解决此问题。
2
将exp逻辑备份文件导入到备库中时出现了错误,相关错误信息如下:
这是个很常见的导入警告,通常与数据库/客户端版本有关。
解决办法,就是在exp或imp时加上一个参数来禁用统计信息的导出/导入: statistics=none
3、
Thank you all for your help. Using orapwd doesn't prevent the database from disconnecting. However, I found the solution from metalink:
1. Login as sys in the SQLPLUS and run the following sqls
$OH/rdbms/admin/dbmsread.sql
$OH/rdbms/admin/prvtread.plb
2. Retry the import.
Thanks!
1. Login as sys in the SQLPLUS and run the following sqls
$OH/rdbms/admin/dbmsread.sql
$OH/rdbms/admin/prvtread.plb
2. Retry the import.
Thanks!
4
为了使测试与生产数据保持一致,只需要导出数据的时候,可以将测试库的表truncate,保